Find records referring to the currently viewed record

[stonerose]

I have two tables: Projects and Outcomes. A Project can produce multiple Outcomes.

When an Outcome record is created, users specify the "Mother Project" through a dropdown populated with values from the Project Number field in the Projects table.

I want to create a button in the Projects table that finds and shows Outcome records with the Mother Project value that is the Project Number of the Project record they are currently viewing.

Can someone help me? I'm a complete FileMaker neophyte...

[bcooney]

Read up on portals. They will allow you to see a list of Outcome records that are related to Projects by ProjectID.

[stonerose]

Okay - I have this half-working. I created a portal. But the portal only shows the first related record. I know FM is identifying all the related records, because I made a value list and a GTRR button based on the related records, and they all show up there. Any advice?

Edited September 23, 2009 by Guest

[comment]

You have two options here: either create a new self-join relationship to show sibling outcomes, i.e.

Outcomes::ProjectID = Outcomes 2::ProjectID

and use a portal or GTRR to show them, or grab the ProjectID from the current record into a variable or a script parameter and use it to find the sibling outcomes.

[bcooney]

You have a relationship from Projects to Outcomes by ProjectID, correct?

The portal should be using this relationship, and all the fields in the portal should be using this relationship (from the same context) as the portal.

Is this so? Can you post a screen shot of your Relationship Graph and Project form layout in Layout mode?

[stonerose]

Well, the portal functioned properly when I re-created it. Not sure what was up there. Thanks very much for your help!

[bcooney]

If you turn on Allow Creation of Records..." in the relationship, then you can create Outcome records without ever leaving the Project form.