dmgraham Posted July 21, 2010 Posted July 21, 2010 I'm new to OSC and am integrating it with my back-end database system. I was surprised to find that the products_id column in products_description was set to auto-increment. The schema makes it appear that the products to products_description is 1 to many based on the languages_id. Since I'm planning on pushing my products via OBDC from our back-end system it seems nuts that I would have to increment both tables or run the risk of descriptions getting out of sync with products. My first thought was to simply turn off auto-incrementing on the foreign key in products_description, but I'm not sure if I'm going to be causing problems. Can anyone please clarify the thinking behind the current setup? TIA, Dave Graham
curVV Posted March 24, 2011 Posted March 24, 2011 Hi, I'd also like to know... Do I have to get the next AUTO_INCREMENT value for products, make sure the MAX value of products_description.products_id is not greater and then do the insert? :-" What might be the reason for this thusness?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.