Created a System View that is not visible in advance find
Hi,
Many to Many relationships are unfortunately not offering the same search results as a N-1/N-1 relationship would. This is because the system intersect table is not directly accessible in Advanced Find.
For this reason I recommend to build your solution with a manual intersect table. You can then run your advanced query. The intersect table would contains look ups to both table, but also from a future scalability perspective it potentially allows you to add additional columns in the future.
As an example - A Contact can go to many Events, and an Event can be attended by many contacts == Many to Many
But now we create a manual intersect table called "Contact at Event" with a look up to the contact and a look up to event.
Then we can add other information in the future if needed. for example, who could have foreseen that you needed to do a COVID test everytime you wanted to go to an event - So the new table can be configured to include new fields to capture date of covid test, and covid test result for example.
If it is too late to create a manual intersect entity - then you can also write a custom FetchXML query. Or possibly a Power Automate query that that flags TABLE1record with no related XYZ records and adds that flag to a custom field on the table 1. You can then filter by this field in Advanced Find.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.