We'll need to see what your relationships look like. Here are two simple ways to show your relationships (use both):
Table1----<table2 (---< shows 1 to many relationship)
Show the match fields like this:
Table1::Field = Table2::Field AND
Table1::Field2 = Table2::Field2
A quick check for differences would be to check the following:
Check the field types of your fields to make sure they're the same for all sets of match fields in your relationships.
In your name field, check for invisible characters such as a space character that may keep records from matching like you expect. (Name fields BTW, except for certain specialized uses, aren't a good field to use in a relationship.)
The Report table is the many table for all others. The relationship is as you wrote,
Report::ID-fk = Table(2,3):: ID , a Number field.
Report::TableName= Table1(2,3 ):: Name, a "text" data type required.
Thanks to your field type note I found the mistake:
The value for Table1(2,3): Name
is a calculated value, only the working table specified "Text" as the calculation result type, which is what was needed, the others were set to number ! Thank you very much for the pointer!
It works now without problem.