AnsweredAssumed Answered

Multi Conditional ValueList Base on Primary Key

Question asked by RockSure on Apr 12, 2015
Latest reply on Apr 13, 2015 by RockSure

Title

Multi Conditional ValueList Base on Primary Key

Post

Multi Conditional ValueList Base on Primary Key

One Contact can have many ContactActions and one ActionMktProgram can have Many ContactActions.

I have the following tables and relationships:
Contact---àContact Action
ActionMktProgram(PK)----à Contacts Action::_fkActionMktProgram
ActionMktProgramType(PK)----à Contacts Action:: _fkActionMktProgramType
ActionMktProgramCampaign(PK)----à Contacts Action::_fkActionMktProgramCampaign

My layout is based on Contact with a portal based on ContactAction I need to progressively  limit the popup selection in Type as a Program is selected and then respectively in Campaign as a Type is selected in the portal.
I was able to achieve the conditional valuelist as per filemaker help file based on match fields but not PK and FK fields. 
 

Is using Pk & FK for VL the incorrect approach? I was treating the Program Table as more than just a VL table.

Outcomes