Relate function multiple relationships between tables

Like (0) Share

Report

Posted on 22 Mar 2022 13:08:00 by 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?

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (1)

Answers (0)

Drew Poggemann 9,278 Most Valuable Professional on 22 Mar 2022 at 17:59:53

Like (1)

Report
Re: Relate function multiple relationships between tables

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

Was this reply helpful? Yes No