Using "Yes" Checkbox to hide records from a layout through a table

Discussion created by mrcrister on Mar 30, 2012
Latest reply on Mar 31, 2012 by mrcrister

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?