How to connect two fields?

  • Thread starter Thread starter Paola
  • Start date Start date
P

Paola

I have a table that I want to create and link to another
table.

One of my tables only has the job number and the Job name.
I want to create a look up function where I can click on
the project name and automatically the job name will
appear.

For example:
job 108 - Guadalupe River
If I click on the number 108 then the project name will
appear as well.

Please advice.

Thank you.
 
Create a select query using one of the tables. Add the second table
using the number as the link. Then add whatever fields you want from the
second table. Now you have a query that has all the data you want. You can
use that to display the name anytime you want.
 
Back
Top