Title
Multiple Password Protected Signature on 1 Record
Post
Hi,
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.
Daniel
Hello Danie,
It seems above you want to store multiple Signatures for the same user
So your Table1 will be user table where you need to store UserID_pk, UserName and Password
And Table2 will be UserSignatures where you need to store the Signature and the UserID_fk
And the matching key between Table1 and Table2 is by UserID_pk = UserID_fk. So you can create multiple signatures stored in Table2 for a specific User in Table1.
Thanks Elishree
FileMaker 11 Certified Developer
Senior Software Engineer
MindfireSolutions
http://www.mindfiresolutions.com/