Specifying custom record limits
I want to restrict access in my database so that any user can only see his/her own record plus records related to him/her in other tables.
I set the custom record access privileges for the Registrants table using the formula "Email = Get(UserName)" (users are required to
use their email address as their username). For other tables that are related back to the original Registrants table I used
"Registrants::Email = Get(UserName)".
This simply doesn't work. In any relevant layout all the fields are filled with <No Access> where I was expecting most to be blocked
but some to be visible.
Any clues as to what I'm doing wrong?