Many to Many relation and Go To Related Record

[Creek]

I have many to many relation. ( T1 ---< JT >--- T2 )

I created two layouts based on T1 and T2. Both layouts work in List View.

For several days I'm looking for solution of the following problem:

JT (Join Table) represents history relations. I stand on the layout T1. I want to display related records from T2 but only the most recent ones. ( T1 ---< T2 ) .

many to many and GTRR problem.fmp12.zip

[Creek]

Sorry I'm not sure if my problem is clear enough. Let me give you a next example.

Table T1. Two records (ID, Name)

1 Tom

2 Jerry

Table T2. Four records (ID, Products)

1 Milk

2 Cheese

3 Water

4 Fish

Table JT.

1 (Tom) (milk)

2 (Jerry) (milk)

3 (Jerry) (cheese)

4 (Tom) (fish)

In this situation when I stand on the record Tom (layout T1) I want see in layout T2 one record: 4 fish. When I stand on the record Jerry I will see 2 records: 1 Milk and 2 Cheese.

Please help me.