Bind ID field to another field

  • Thread starter Thread starter stvlai
  • Start date Start date
S

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