Hi,

I am having trouble trying to setup 2 tables. I am not sure of how they should be related. I have one table Inventory and one table Product Request Details. The Product Request Detail table contains
LB1, LB2, LB3, etc. each of these LB fields
has a Product 1, Product 2 within the Product Request Details table. The LBS and Ingredients should be linked to the Inventory table. When the number of LBS are entered for each Product within the Product Request Details table. I would like to run a query which would update the LBS associated with each unique product within the inventory table. Am I conceptualizing this is the correct manner? Any other suggestions?

I appreciate any help.

Thanks so much.

As a matter of "good practice" you should NEVER EVER use fields that are numbered like that. -- well maybe once in a while if you find below is to complex for LB1 and LB2 --

So if you have a product made up out of parts try this design

ProductTable
ProdID
ProdName
....

PartsTable
ProdID
InvID
Weight
Number...

InventoryTable
InvID
InvName
.,...

Hope that gives you a push in the right direction

Regards