AnsweredAssumed Answered

Newbie question - Lookup multiple records?

Question asked by Sewlong on Mar 23, 2009
Latest reply on Mar 25, 2009 by Sewlong

Title

Newbie question - Lookup multiple records?

Post

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!

Outcomes