Jump to content
Sign in to follow this  
SteveS

Digital Signature Fields Revisited

Recommended Posts

Months ago I inquired about digital signature fields, members responded and gave me good tips. I do have some related issues to solve and hope you can help me.

I designed a layout report that includes two text fields at the bottom. One field designated for the SUPERVISOR and the other field designated for the TRAINEE. The Supervisor and Trainee sign off when the report is completed.

It was suggested earlier that I set the “Field Level Access” for each field in the ACCOUNTS & PRIVELIGES section to limit who has access to the SUPERVISOR field and the TRAINEE fields. That seemed to be a logical solution at the time but I realized another problem, any supervisor can enter whatever name they desire in the supervisor’s signature field and any trainee can enter any name they desire in the trainee’s signature field.

Another member’s tip requested the following; Get(accountname) “unstored” which will give me the current user who is logged in. Many users do not use their full name as their log-in screen name.

I set up the database for users to log into the database with predefined account names based on account privileges. Example – Supervisor1, Supervisor2, Supervisor3…. Trainee1, Trainee2, Trainee3… all have individual passwords.

If the account name “Supervisor1” is assigned to user “James Brown,” how can I set the signature field to only accept text entered as “James Brown?”

Thank You

Share this post


Link to post
Share on other sites

Maybe my previous post was not clear, let me ask you this. If you designed a paperless database and have two text fields designated for a Trainee & Supervisor's name, how could you authenticate the user who entered their name inside their designated field?

Any help would be greatly appreciated!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.