still trying to figure out M to M relations

Classic Servoy
1

main table is Matter. name_xrf is a m to m related table by matterid.
name_xrf is related to name(one) file using nameid.

Now, I have a form that lists records from the Matter table.
User clicks on a record in list to view details of Matter table record in dialog. This form has a tab with a portal showing all related records in name_xrf (many) table.
So far thhis is all working.
Now I want the user to click on a button on the portal line to view the fields from the related name table in another form in dialog.
On the form maParties which is the form referenced by the tab in the portal, I do

//showNameDetails[maParties]
controller.loadRecords(matter_to_name_xrf)
forms.name_xrf.showNameofNamexrf();

Then:

//showNameofNamexrf[name_xrf]
controller.loadRecords(name_xrf_to_name)
forms.name.showNameInDialog();

Finally:

//showNameInDialog[name]
nameLock();
forms.name.elements.butAccept.visible=false
forms.name.elements.butReject.visible=false
application.showFormInDialog( forms.name, -1, -1, -1, -1, " Name Record details");

I get an error message saying Cant set a foundset from table {0} into a form using table {1} How do I do this?

2

those 2 controller calls with loadRecords() are those 2 scripts on the same form?

If so then this is a logical error (that you see {0} and {1} are fixed in 2.1b5)

You can’t set data from one table into a form that is based on another table.

it looks like you have to do this:

//showNameDetails[maParties]
forms.name_xrf.controller.loadRecords(matter_to_name_xrf)
forms.name_xrf.showNameofNamexrf();

and

//showNameofNamexrf[name_xrf]
forms.name.controller.loadRecords(name_xrf_to_name)
forms.name.showNameInDialog();