I'd like to use a checkbox to hide certain records from various table instances.
A person record has Leader checkbox. Simply a Text field with checkbox data field on the layout using a Value List containing only Yes. When the checkbox is checked, the record appears in the special table, otherwise it is hidden. Sort of a query built into the relationships table.
What I have tried to do is make a table instance and say that the Checkbox field must equal Yes (a global field I've created in a settings table) but it isn't working quite right. I've got more than one checkbox counting on this. Any ideas?