ID Showing On Form, NOT Number

Hello,

I am building a relatively small database, but it is made up of a number of different tables which are fed by other tables.

My three main tables are:

EmployeeDetails
Occupational Risk Profile
Health Surveillance Requirements

The employee details table has fields fed by small tables such as Department, Location, Business Unit, Occupational Group etc. These are all made up of an autonumber primary key column and a variable column as described above.

I have been going round in circles with a lot of this as I am still learning.


My problem is that on my forms these fields are showing as numbers and not the text values. For example, I have one form made up for each of the main tables above but I can't get them to display the relevant text.

I did a search on here and somebody said to create query to link the tables and bind this query to a form.

How do I set up the query just to return the text part and not the number?
How do I bind this query to the form if I already have the record source on a my form as a table? (can you have more than one source in the record source?)
Do I create one large query with all of these fields and use this as the basis for the form?

Thanks