Multiple Password Protected Signature on 1 Record
I am trying to create a solution for password protected signatures in my database. The signature itself can just be the persons name but it has to be password protected. I currently have two tables each in their own file. One we can call "Form" and the other "Password Directory". Password directory has fields: User ID, Password, Signature. Form has fields User1, Password1, Signature1. User1 and Password1 are entered via custom dialog box. The calculation I currently have for Signature1 is:
If(User1=Password Directory::User ID and Password1=Password Directory::Password;Password Directory::Signature;"Incorrect User ID or Password")
I have the tables linked by User1=User ID. This solution currently works fine. The problem is I need multiple signature on the same record. I added the fields User2, Password2, Signature2 to "Forms" with the calculation for Signature2:
If(User2=Password Directory::User ID and Password2=Password Directory::Password;Password Directory::Signature;"Incorrect User ID or Password")
I kept the relationship the same. When I enter different user credentials into user2,password2 I get the "Incorrect User ID or Password" message in signature2 even though it was entered correctly. It only works if the user information is the same for both user1 and user2. I have tried changing the relationships and the calculation but can not get it to work for two different signatures on one record. Sorry for the long post I hope it is somewhat intelligible. Thanks for any help I really appreciate it.