Relationship problems

[BarbT]

I am trying to create a report from 3 tables, Students, Measurements 1 and Measurements 3. However, I am getting an error message: You have chosen fields from these tables: Students and Parents, Measurements 1 and Measurements 3; One or more of these tables isn't related to the others. Click OK to edit system relationships.



As I have created relationships and these tables seem to be related together, I cannot see how to edit this. Any help would be most appreciated.

[RuralGuy]

I don't see any relationship to the [Measurements 3] table.

[BarbT]

Please can you tell me how to do that as I am struggling with it.

[RuralGuy]

In the Relationship screen, just left click the [Student ID] field of the [Students and Parents] table and drag it over to the same field in the [Measurements 3] table and drop it. How did you get the other relationships?

[BarbT]

Thank you, I will do that. The trouble is that I did this some many months ago and can't remember how I created relationships! Anyhow, I think that this makes sense, so many thanks for your help.

[RuralGuy]

It is a visual thing and will correct you if it is not a valid relationship.