View Full Version : store similar data sets in one single record


ymaccess
02-28-2010, 04:30 PM
Hello,
I need to include several sets of similar data in the same record :
Simplified problem : I need to quote for one or several (up to 10) boxes of non standard size. I want to store in a table each box's ID together with its dimensions and price, then store in another table the quote's ID and the IDs of the boxes included in this quote.
BUT, I do not succeed in linking the two tables (I just started with access ...)
Any suggestions on how to structure my DB
Thanks

vbaInet
03-07-2010, 12:59 PM
I think you're jumping onto things too quick without grasping the basics. You might want to read about relational database concepts and if it helps you can check out Update query and the sql INSERT/UPDATE statement.