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