many to many relationship and Sort

[Creek]

I have a problem with sorting many to many relationship.

I have three tables.

TAB1 - <TAB1_TAB2> - tab2

In layaut based on TAB2 I put a portal (TAB1).

Table TAB1_TAB2 include the fields of foreign keys and filed counter.

I would like to see the data (TAB1) in the portal sorted by the counter from (TAB1_TAB2).

many to many SORT.fmp12.zip

[bcooney]

Why wouldn't you base the portal on the join table?

You can temporarily change the context of the portal so that you can select the "counter" field in the join table as the sort portal field. Then change the context back to Tab1.

[Creek]

Thank you for your quick reply

Hym. It is a solution.

> You can temporarily change the context of the portal (...)

Hym. How to do it?

[bcooney]

Portal setup.