Using two tables on a form

[assassin4213]

Hello Everyone,

Here's the scoop. I have two tables. One that has raw lab data, the other that has vendor names with their specifications.

I have one form that is used to enter the lab data. A vendor is sometimes associated with a data set. I would like to have the database reference the vendor table to retrieve the specifications and put them next to the appropriate data fields. Would someone be able to help me?

Thanks,

Greg

 

[hair]

If the two tables are linked, you should build a query based on those two tables. After this, you can bild the form with the wizard, based on this query.