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
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