I'm implementing some additional access control in our DB. I would like to implement the following on the fly without using a script.
User A is stored in a global field.
User A will be trying to access Table A records on a list layout
Table A is related to Table B
I need to know if User A is present in Table B to give access to Table A records on the layout
Tom(global field) -> An invoice record -> Owners: Tom, Dick, Harry(related records)
If it matches Tom in the related table, it will allow access.
I wasn't sure if a List() or ExecuteSQL would be best to apply. Thanks for any help!