Hi, not been on in a while but an old client has got in touch about something and I am a bit unsure of how big this job could be. Wondering you guys could help advise me better on whats the best way to do it...?
The questions
The problem I have is the first issue of only showing specific data.
Currently, the database has 2 dashboards MANAGEMENT (pass protected) and CONSULTANTS.
The CONSULTANTS dash currently does not display the Contact Form as it has sensitive data. However they need the consultant to now access this form and enter data but "specific" fields need to be invisible or starred **** out when they access it.
Is this possible at all?
Would I be better off creating a duplicate of CONTRACT Form and hiding the fields I need to but linking BOTH forms to the same Source? So when they edit/enter data they only see what they need to see?
Any ideas be great.
Thanks
The questions
I currently have a Access 2010 database which hold information about our clients, their contracts & prices. It is currently split into 2 dashboards, one for consultants and one for management. At the present time, the consultants dashboard does not allow access to the contract form to the consultant (password protected) as it contains sensitive information in some fields. I would need to allow consultants to access that form and enter data but hide the sensitive fields to be seen by management only.
Also I currently have a price form linked to contract with a query/form displaying total contract cost. I want to amend a few fields in the price form and its associated price query, and amend the cost form also ( I want to have the option to enter quoted prices)
The problem I have is the first issue of only showing specific data.
Currently, the database has 2 dashboards MANAGEMENT (pass protected) and CONSULTANTS.
The CONSULTANTS dash currently does not display the Contact Form as it has sensitive data. However they need the consultant to now access this form and enter data but "specific" fields need to be invisible or starred **** out when they access it.
Is this possible at all?
Would I be better off creating a duplicate of CONTRACT Form and hiding the fields I need to but linking BOTH forms to the same Source? So when they edit/enter data they only see what they need to see?
Any ideas be great.
Thanks