Hi Aurelien, Thanks for the response. WIll try out the two methods you shared. Also, was thinking about using the email address as the key value throughout the other tables. Will revert with what I find out. Regards, Jonathan

Hi Marc, Thanks for being patient. So I started all over again. Created the Users table with Email as the key (this has the roles in it: SuperAdmin, CareManager and Patient) Created the Profile table with Email as a Ref Created the Vitals table with ...

Sorry about not being clear. So here is the whole story: I have a Users table with columns: Email (key), Name, Phone No., Role (SuperAdmin, CareManager & Patient), Group, Photo I have a Profile table which has each patient’s typical demographic data ...

You can see what error message I am getting.

Hi Marc, Thanks for the reply. Here is what I have done: Created a slice called “Current User” and the expression USEREMAIL() = [Email]. [Email] is my first column the Users tab. I have the following roles [Role] - “SuperAdmin”, “CareManager” and “Pa...