Mixed ID Numbers?

M

M.A.Halim

I have a data base of 800 employees. Each employee have an ID number.on real
situation, when an emplyee is transferred from one store to another we log
this transfer. I have 2 tables 1 is "Emplyees' Data" the other is "The
Transfers" which of course is smaller in size (Around 60 records only) since
not all emplyees are transferred.
I set a relationship between the 2 tables through the emplyee ID number.
when I open the transferrs report every time I get a different Id number for
the same employee. Is it due to the relationship between the 2 tables or what
can be? Many Thaks.
 
J

John W. Vinson

I set a relationship between the 2 tables through the emplyee ID number.
when I open the transferrs report every time I get a different Id number for
the same employee. Is it due to the relationship between the 2 tables or what
can be? Many Thaks.
Click to expand...

Then you have an error in the transfers report, or its Recordsource query.

Please post some more information about the tables and how you have the report
set up. We can't diagnose a problem we can't see!

John W. Vinson [MVP]
 
Top