Display a number field to appear as names in another field

  • Thread starter Thread starter Adriana
  • Start date Start date
A

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?
 
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?
Click to expand...

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.
 
Back
Top