Script to search records based on password entered

April 13, 200421 yr

Is this possible? I want users to only be able to view records that they created. I would like to have them enter a password and then have a script that would run automatically to find records that they have created only. Is this possible?

Ron

FileMaker Version: 5

Platform: Mac OS 9

April 13, 200421 yr

There are two functions in FM5 that might be of use:

Status(CurrentUserName) - gets the user name from the system settings

Status(CurrentGroups) - gets a list of the access groups that the current user is a member of (from the accounts and privileges)

No other way to do it in FM5 without a plug in or a custom login system. FM7 has built in account management features including the ability to Get(AccountName).

April 13, 200421 yr

Ron:

In the systems I set up I always grab Status(CurrentUserName) and put it into each record as it is created. Then, to find that user's entries, you can do a Find via the same call. You can automate that find via a startup script, which is what one of my clients' systems does. They think it's done by magic.

-Stanley