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.