I am having trouble using the Relate function because I have two relationships and Relate doesn't specify which relationship to use.
I have two tables, "People", and "Meetings", and two relationships between them. A 1:N relationship called "Primary" and a N:N relationship. How can I use the Relate function to relate a "Person" to the "Primary" field in a "Meeting"?
The Relate function works if I only have the 1:N relationship, but does not work when I also have a N:N relationship between the two tables.
I am currently getting the error "The function 'Relate' has some invalid arguments." and my code is
Relate(ComboBox5.Selected.Meetings,ComboBox4.Selected)
Is this an impossible situation where I need to change my relationships? Or is there a solution that I am failing to see?


Report
All responses (
Answers (