My database includes a client list. I would love to be able to allow clients to use it directly to update a particular layout (ie their attendance, capturing date, session, who they saw etc.). However I don't want them to be able to access other clients info.
So is there anyway that when they click on their name, they must enter a specific password (ie their DOB) before they go through to the layout?
You can enter layout mode and set up the field with their name as a button that performs a script. The script can use Show Custom Dialog to open up a dialog with an input field for entering their birthdate. The input field can be set up to use a global text field. The script can check the date entered against their DOB field and do nothing more but display an error message if the two dates do not match.