Filtered Value List

[Daniel Shanahan]

Is it possible to filter a value list in FileMaker? I don't want to reduce the value list. Rather, I would like to show only certain values and I would like to show them every time.

For instance, in the Demo file attached, the parent table has three records: "Guitar", "Amp", "Microphone." On the child record I would like to use a drop-down with a value list in order to set the foreign key. However, I do not want to "Amp". So, every time I set the foreign key in the child record, I would like to see a value list of "Guitar¶Microphone".

Demo_FilteredVL.fp7.zip

[Daniel Shanahan]

Another developer sent me this solution - seems to work pretty well.

Demo_FilteredVL.fp7.zip