Can you have a "AND" statement in the "Where" field when using a lookup table.
I have this in the where field now
"id = ". $_SESSION["OwnerID"]and it is working.
Unfortunately, I also need to filter the dropdown to only show active records in the dropdown. I was thinking something like this:
"id = ". $_SESSION["OwnerID"] AND "active = 1"I tried this and it shows the active records but doesn't respect the "id = ". $_SESSION["OwnerID"] part.
Can this be done?
Thanks for any advice!