Hi, I have a tricky one, or at least I think it is. I have a form that my company uses where a supervisor must approve the information. Right now anyone can just enter the supervisors number, and it works because the supervisor usually just glances at the info and tells the employee it's okay. We want to make the supervisors more accountable. I was thinking of a button which would pop up a window for authentication: employee number and password. If it's a go, then next to the employee number a digital capture of the supervisor's signature would automatically be entered into the container field.

How do I do this?

V

Look into the use of the Custom Dialog scriptstep. It's not going to be 100% though.

Steven

Your question intrigued so I spent some time designing a script preventing a user from modifying a value unless a supervisor is present. When a user wants to override a value, the supervisor clicks a button and enters their account and password. The Re-Login script step is used to temporarily change the security level so the field modification can be made. Once it is complete, the user account and password is required to continue. In other words, the supervisor and user have to be present to override the value.

The script is fairly complicated with several loops, error checking, etc. There is even a FileMaker 7 and 8 version of the script. Hope this helps!

SUPERVISOR.zip

Very Very Cool John, thank you so much.... I'll use it and mod it to what I need... but I would have never come up with all that!

A very appreciative Vandy