With Filemaker 6 I can have a field called modifier name that will always show the last modifiers name. But this modifier name is the name that

To do this you will need to create your own login system. The user name won't be accessible as the "Modifier Name" but as a name entered into a field. FileMaker has passwords, but no notion of user unless you build one.

-bd

We are currently implementing foolproof system with combination of both -- FM internal security and login database.

For that we need plugin Dialog Magic. The license is cheap for larger company; I think $7 per user in quantity 100 users.

We will have login database with user login, password and user name and expiration date.

With Dialog Magic we will log user to FM databases, set his/hers identity in User Name and write that to global field. User will never know the FM password or group.

If user will try to disable the plugin, or change User Name it will be discovered in next script operation and FM will quit.

All important fields will be with autotracking, keeping previous changes in log field.

I cannot think of any other way to design more secure system.