Filtered Listing?

[jjfcpa]

First off, I have a relationship as follows:

Clients

Loans

Payments

The clients have a primary key that is also in the loans table (as a foreign key). The payments tables has a primary key from the loans table (as a foreign key).

I am not using a portal because of the design constraints.

I have a Clients Listing that allows you to display a clients details screen, and from that screen you can go to the loans listing screen. Currently, the payments screen is not finished.

The problem is that when I go to the loans listing screen, ALL the loans for all clients are displayed. I thought that the relationship would filter only the loans for the client selected; however, I think I probably need to do something. Just not sure what. I'm thinking maybe a find on the primary key of the client in the loans table?

Help very much appreciated.

[comment]

I think I probably need to do something. Just not sure what.

This?

http://www.filemaker.com/11help/html/scripts_ref1.36.20.html#1028356

[jjfcpa]

Thank you for the reply.

Should this script step be done AFTER performing a find in the loans table based on the client's primary key?

[comment]

Instead. If you check "Show only related records", this step does everything you need: goes to a layout of loans and shows only the loans of the selected client.