AnsweredAssumed Answered

Differentiate a calculation depending on who is logged in

Question asked by StefanÖstlind on Apr 20, 2012
Latest reply on Apr 20, 2012 by philmodjunk

Title

Differentiate a calculation depending on who is logged in

Post

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.

Outcomes