Relate function multiple relationships between tables

[jawalley]

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?

[dpoggemann]

Hi @jawalley ,

Question for you, you appear to be trying to link a related record to the ComboBox1 that would be multiple records right?  Is Meetings a "single" record?  It needs to be, so I would think something like the following might work in your case:

Relate(First(ComboBox5.Selected.Meetings),ComboBox4.Selected)

Not sure if this makes sense for your situation