I am really new to FM and I am stuck. So... I have a contacts layout with a portal looking into a roles table which shows me all records related to the contact. There is a "Active" checkbox in the roles table.
I am trying to set up a portal filter based on a radio button on the contacts layout that says "Active Only" or "All".
I used a case statement to show only the records in the roles table that say "is active". That worked! I am stuck at then making the filter show all of the records. The table column can contain "active" or can be empty.
This is what I wrote into the filter dialog:
Contacts::Contact_Active_Option = "Active Only"; Roles::Roles_Active = "Is Active";
Contacts::Contact_Active_Option = "All"; Roles::Roles_Active = "Is Active" and "";
The first statement works, the second does not. So, when the user clicks the "All" option it should show the records with "Is Active" and the records that are empty.
Thanks for any suggestions you may have.