silvertabb
Active Member
- Joined
- May 18, 2004
- Messages
- 252
hi,
i have a table which contains the lot #.
another table contains components that were used to make the various lots.
for example, lot # 1000 and lot #2000 make up is as follows:
components 10, 20, 30 were used to make lot# 1000
components 10, 30 were used to make lot #2000
as you can see, component 10 and 30 are shared by both lots. if i were to look up this info in access, how should i set up my tables?
i have a table which contains the lot #.
another table contains components that were used to make the various lots.
for example, lot # 1000 and lot #2000 make up is as follows:
components 10, 20, 30 were used to make lot# 1000
components 10, 30 were used to make lot #2000
as you can see, component 10 and 30 are shared by both lots. if i were to look up this info in access, how should i set up my tables?