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.
FileMaker 11 Certified Developer
Senior Software Engineer
This looks like something that could be managed through Filemaker's accounts and passwords instead of creating your own password system. You can use FileMaker's account name/password system to limit each user's access to specific records--such as their signature record(s).
See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a description of how to set this up.
Thanks for your quick reply. I didnt explain that part well. I need multiple signatures on one record for different users. So one user could enter their credentials in fields user1 and password1 and if correct it would place their signature in signature1. Then a different user could enter their credentials in fields user2 and password2 and if correct it would place their signature in signature 2. Both on the same record. Hope this helps. Thanks again.
Thanks that actually answers a different question I had as I will need to restrict access to records but I still need to capture the signatures on the form itself. Basically, different users will fill out different sections of a form and they need to sign the portion of the form they completed. Or there might be a form where 3 different people are required to sign for approval. We need to capture the signatures as evidence and they have to be password protected to be compliant.
And that password protection can be set up via Manage | security so that the only signature that they can select is their own. Joe Smith can't sign the document as June Jones because he can't access her "signature" record.