Linking table value to a text field in a form

[newbie_204]

Bit of a newbie.... I have two tables... one for Job_Setup information and a second for Job_Status information; they currently have a relationship via the Work_Order value, and the relationship appears to be correct as my sub tables display the information of the opposing table. I would like to have a text/label in the Job_Setup to DISPLAY, not store, the value that is stored in the field Current_Status in the Job_Status table. I am assuming I have to query each table against eachother? Any help would be appreciated.

[RuralGuy]

Have you tried creating a query that joins the two tables? You could then show fields from either table as if they were in one table.