So I'm trying to set up a security access so the sales department can only see pieces available for sale only. I have a column that designates sold with S and A for available. I need to script the security so that it finds and shows only the A pieces and hides or doesn't show the S pieces.
I'm thinking an if statement but I'm not sure. I've written the following but this doesn't work. Help is much appreciated. Thank you!
Go to Layout ["Gallery Price List"]
Go to Record/Request/Page [First]
If [Art Database::Status = "A"]
Do Not Show
Go to Record/Request/Page [Exit After Last, Next]