I have a table of accounts that can login to the database. Accounts are assigned a certain privilege sets.
I also have a field in the accounts table that lists the kp's of records in another table that the acount is authorized to edit and view.
How do I use the calulation in the security feature to access these kp's? I was thinking about using the filtervalues function but the problem comes in determining how to access the approiate kp's for the account that is logged in.
Anyone know what functions I need to create or if I need to create another global calcualtion field?