Linking multiple items in a table

Janet Niblock

New member
Local time
Today, 07:32
Joined
Dec 12, 2011
Messages
5
I am designing an inventory database at the moment to book stock in and out. I have all of the components logged in a table (Stock Item - JPG attached).

Some of the stock items have individual asset numbers but are part of 1 bespoke machine we call "Noah". If I put in a new stock item i.e. Noah, how do I link all of the other stock items included in the machine (Numbers 105 - 112 in the attached JPG) to "Noah" so when that stock item is chosen, the rest of the linked items are booked out of stock?

Any help would be greatly appreciated - Many thanks in anticipation!

Jan :o
 

Attachments

  • Stock Item table.jpg
    Stock Item table.jpg
    97.3 KB · Views: 112
I am designing an inventory database at the moment to book stock in and out. I have all of the components logged in a table (Stock Item - JPG attached).

Some of the stock items have individual asset numbers but are part of 1 bespoke machine we call "Noah". If I put in a new stock item i.e. Noah, how do I link all of the other stock items included in the machine (Numbers 105 - 112 in the attached JPG) to "Noah" so when that stock item is chosen, the rest of the linked items are booked out of stock?

Any help would be greatly appreciated - Many thanks in anticipation!

Jan :o

In your graphic, I see nothing that ties 105 through 112 together. Do you have another table that links items in certain groups? That might accomplish what you are looking for.
 

Users who are viewing this thread

Back
Top Bottom