ID Numbers

[David Barash]

I am doing a quality assurance report where I want the names of the
employees to be blinded. I have one table with all the data and the names,
and another table with the names and ID numbers. How do I create a report
that displays only the ID numbers with all the quality data?

Thanks.

--

David Barash
dba...@cris.com

[Roger Mann]

You need an ID column in your "many" table which relates to the ID in your
"One" table. At the moment it sounds like your Name field is the
identifier, but generally this isn't good practice since forcing unique
names is difficult.
Base your report on the 2 tables and bind one field to the ID and the
others to the quality data fields you want to show