AnsweredAssumed Answered

Lookup if no value...

Question asked by productionQC on Jul 31, 2013
Latest reply on Jul 31, 2013 by philmodjunk


Lookup if no value...



     I have a table called Products and a table called Tests.  What I need to do is create a portal that shows only the products that have not been tested, that have no test number assigned.  Thus, when an employee looks at this portal they can quickly tell if a product has been tested in the history of the database.  Do I use a Lookup to determine if the productcode exists in the tests table?  If so how, what relationships etc...  Right now the relationship is  TESTS:Mixcode >--------< Products:Mixcode as I have a dropdown menu on Tests that allows the user to select a product to bring up all corresponding test. 

     Thank you!