Differentiate a calculation depending on who is logged in
I have a database I want to share with my clients. This is the setup so far:
T1) Company name and unique ID and Markup percentage.
T2) Products with Products' ingoing cost and other information, including Selling Price.
T3) Contacts, connecting to Company Account ID (T1), also includes a Online User Name that is equal to the account name
Now, I want to have a layout that my client can view and see the contents of T2 but the field Selling Price must be calculated with the correct markup for that Company. Otherwise the product catalogue is the same.
Being a bit new at this, I struggle to get the functions in a calculation and would so appreciate some help to get going.