lookup in combo box

[wolfm]

I have a field in Form[Truck Runs], that contains a combo box to pull up job numbers from Table [Shows].
As a double-check during data entry, I would like the user to be able to see, in the second column, the job name for that job number, also pulled from Table[Shows].
When I tried to add field Job Number to that combo box's query, it messes up my queries by eliminating records from run queries.
So, I guess I'm not sure how to add a column to a combo box.



I would appreciate any help! Thanks. My database attached...Truck Runs Condensed.zip

[RuralGuy]

You mean like this?

[wolfm]

Great! Thank you!!

[RuralGuy]

You're welcome. Glad we could help.