Newbie question - Lookup multiple records?
I am using a table to create records for the “Generic Items” I build at my shop, I use 2 joining tables to calculate the typical cost of the “Generic Item” i.e.. “Join Materials” & “Join Labor” tables.
I then have a table “Projects” that looks up the generic item information so we can produce a Specific Item. What I would like to do is have the ability to Lookup all of the related records from the “Join Materials” & “Join Labor” tables so I can change them for the specific project with out changing the original “Generic Item”
How do I go about this?
Thanks in advance!