Display information from one table based on another table's ID

[eroche]

I have a form that is displaying bids (via a job id) for a job record. I would like to "display" the name of the job in an unbound field next to the Job Id field. ie. not save just show it. Any help would be greatly appreciated!

Job Table: Job Id, Job Name, address....etc.


Bids Table: Job Id, Bid Id, Material Name....

In my form for Bids, I want to show the Job Name (next to the Job ID) so that the user knows which job he/she is entering bids for....
Thanks,
Elizabeth

[NTC]

the correct answer depends on your interface design; fundamentally your Bids table can be joined to the Job table in a query - - and then you can include which ever fields you require. Then save & make the query as the record source for your form / sub form

[eroche]

Thanks so much. I can make that work!! (I used to work in the Oracle SQL*Forms environment...many, many moons ago...learning how to make it all work in Access...