I want to filter several value lists based on an “enabled” flag. ie, an Employee list, and I only want to show records from the employee table where the “enabled” field == 1.
What’s the best way to accomplish that?
I’m sure there’s a way to setup a relation that would handle it, but I’m not sure I’m seeing the easiest way to manage it.
Thanks in advance for any ideas.
g.
Couple of ways:
a) Create a global variable called “constant” (or something) - make it an INT with a default value of 1. Then you can include that field in your relation along with your primary key.
b) You can create a SQL statement and populate the list that way at runtime.
Both are going to be fast and reliable - just use which ever version makes the most sense to you.
Hope this helps.