Hoping someone here can help me on this.
Trying to use a drop down that uses a value list that loads employees from there table.
I have a extra field in the employees table called "Active" which is either "Yes or No".
I want to load only the employees that are active into the drop down value list but I'm having trouble dealing with the active part?
I'm used to writing sql statement that would just use the "AND" clause to make this work.
Any help on this is appreciated.