I have 2 tables (User table & B Table) linked by User_ID. B Table has its own serial_ID and Location_ID.
I want to hide a button when the Location is looked up and a related record already exists for that Location (I have an Auto-filtering Search Portal setup and when a portal row is selected, a $LocationID variable is stored).
My thought was hide object when: User table::User_ID = B Table::User_ID and B Table::Location_ID=$LocationID and not IsEmpty(B Table::serial_ID).
But when I put in the above it just stays hidden the entire time. Where is my error?