I am building a workorder database and have run into a stump.



I have a table with rank, one with employees, and one with work orders. The employees table incorporates the rank fine, but when i try to build a form to input the emplyee assigned to the work order table the rank shows up as a number (the primary key). I have tried a lookup field in the employees table, which I have read is a bad idea, however, I get the same if I try to create a form for the same purpose. I have checked the relationships and they seem to make sense, though I admit to not being an expert.

So in other words, how do I create the connection from the work order database to the employee database, and display the rank properly.

thanks in advance.