How to connect two fields?

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.
 
Top