Acess lookup table

Hello, This is a basic question that I have not been able to find an answer in the help files.

I have a “workorder number” field in table 1 and also a separate a work order table.

When I enter the workorder number in table 1, I want it to go to the work order table and pull in information such as client name, client number etc. so that I don’t have to type it in. Thanks,