filtered portal field value list

[john9210]

I'm trying to figure out how to attach a filtered value list to a field in a portal. A copy of the solution is attached. I want to filter the value list attached to the fkMemberID field to display records with Member::Status = inactive.

Meetings.fmp12

[LaRetta]

Hi John,

The easiest way is to create a calculation field in Members, maybe called InactiveMemberID, as data type number to match your pkMemberID, with:

If ( Status = "Inactive" ; pkMemberID )

Then create a value list called Inactive Members. Base the value list upon InactiveMemberID in the left pane and Members FullName in the right right pane.  Include all records.

[john9210]

Perfect solution! Thanks for your help.