I am trouble trying to use a dynamic multi-key relationship to display data in a portal

From the Main Table the User selects a name from the pull-down value list.

The listFIELDcalc is the multi-key field to a portal from the Incoming Data Table.

Is it possible to have a dynamic multi-key field from a calculation field.

If so what is the best way to do this?

NOTE: The incoming data comes from an external source and does not have a name field

TESTdb1.fp7.zip

Edited January 4, 200818 yr by Guest

What you have is actually working - you just cannot see it, because the window is not refreshing (add a button defined as Refresh Window [Flush cached join results] to the layout to see what I mean). The window is not refreshing, because Filemaker isn't aware of a connection between the two relationships.

You can solve this by defining your listFIELDcalc as:

Let (

trigger = Name

;

List ( SystemCodes::PubAndRun )

)

Alternatively, change to a cascading relationship as shown in the attached.

Thanks Comment

I wonder if someone could review the attached database and let me know if I am on the right track or if there is a more elegant way to do this.

I have used the trigger example that Comment mention in the previous post to populate dynamic value lists which drill down the data from the IncomingDATA table.

Because the data imported is all numerical, I have created a table "SystemCodesNamed" to generated a descriptive pop-up menu list that the user selects from.

I have sample data entered for Jan 8 (Retail), 9 (Display, National) 10 and 11, with most of it for Jan 10.

TESTdb2.fp7.zip

Edited January 10, 200818 yr by Guest