Viewing Many to Many Information

(0) Share

Report

Posted on by Bahalzamon

I am attempting to view information from a Many to Many connection through many avenues.

I would like to see what selections I have made from a N:N connection within a View. I have 2 tables, Reports and Classrooms with a N:N connection. So on the Reports form I have a sub grid where I select several Classroom records.

I have attempted the PCF Gallery and using the Custom NToN Multiselect Lookup which only partially works as in it displays the drop down properly but no information is saved and errors out when opening a created record. Despite my efforts I cannot get it to work, I may be wrong but my thought is possibly it no longer works as it has been a couple years on updates and MS has released this function in an OOB solution with the Field Service addition for an additional per user/month cost.

Any recommendations/suggestions are welcome. If the PCF solution is still a valid option I will post my images of how its set up for troubleshooting.

All responses (4)

Answers (1)

Bahalzamon on at

Like (0)

Report

RE: Viewing Many to Many Information

Abby Kong I cant believe I forgot to add that, thank you so much for the reply, that solved the issue. :)
Verified answer

Abby Kong 6 on at

Like (2)

Report

RE: Viewing Many to Many Information

Hi Clinton,

I suppose you are missing the prefix on the relationship name and table, like showing in your screenshot.

Regards,

Abby
Bahalzamon on at

Like (0)

Report

RE: Viewing Many to Many Information

I have the solution imported:

Here is the field named Classroom on the Reports form:

Here is the relationship:

On the Report form it displays the available classrooms just fine:

once saved it shows fine, but also doesn't show in the sub-grid below:

closing then reopening the form i receive an error:

looking at the table data it is saving the information int he column:

I have tried many variations on the information input into the field with no luck so far.
Naveen Ganeshe 3,393 User Group Leader on at

Like (1)

Report

RE: Viewing Many to Many Information

Hi Clinton,

Can you share some screenshots regarding this?