4 Replies Latest reply on Feb 10, 2017 2:33 PM by Jaymo

    How to find 1 exact related record in a calculation

    FMHarv

      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!