Bind ID field to another field

[stvlai]

Hi

I use a Combo Box (link to Staff Table) and the data save the ID of
the Staff Name to Table 01. So, when I try to print on a Report from
Table 01, it prints only the ID not the Staff Name. The Staff ID &
Name is in another table call Staff.

How do I bind the ID to the Staff Name field so the Report prints the
Staff Name not the Staff ID?

Any info would be very much appreciated. Thanks

SLKW

 

[Jerry Whittle]

You join the two tables in a query linked on the ID field. You bring down all
the fields that you wish to see on the report from the two tables and create
a report based on that query.

 

[stvlai]

Thanks for the help Jerry! Will try that!

SLKW

You join the two tables in a query linked on the ID field. You bring downall
the fields that you wish to see on the report from the two tables and create
a report based on that query.