Mixed ID Numbers?

[Guest]

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.

 

[Joseph Meehan]

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.

How about showing us all the related tables and the types of
relationships and the fields in each table that form those relationships.
I just can't get my head around exactly what you have based on the
information you provided.

 

[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.

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]