Display a number field to appear as names in another field

[Adriana]

Hi:

I'm stuck on something that I just can't figure out. I have one table with
5 fields of Clock Numbers and another table where those Clock numbers
correspond to employee names. In a query that will be the source data of a
form, how do I make the 5 fields of clock numbers show as names?

 

[karl dewey]

Explain what is a 'Clock Numbers'.

 

[John W. Vinson]

Hi:

I'm stuck on something that I just can't figure out. I have one table with
5 fields of Clock Numbers and another table where those Clock numbers
correspond to employee names. In a query that will be the source data of a
form, how do I make the 5 fields of clock numbers show as names?

Create a Query joining this (BADLY NON NORMAL!) table to *five instances* of
the employee table, joining each one to one of the clock number fields.

You really should consider restructuring your tables - someday you'll need a
sixth person and your database won't let you! A one (task? day?) to many
(employees) relationship should be modeled with two tables, with five (or
however many) records for each record in your current table.