AnsweredAssumed Answered

How to find 1 exact related record in a calculation

Question asked by FMHarv on Feb 10, 2017
Latest reply on Feb 10, 2017 by Jaymo

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

 

Example:

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!

Outcomes