Is it possible to list all active accounts in FileMaker via a script?

No, not directly. I believe FileMaker would consider that a security risk. It is possible to get them from the DDR (Database Design Report).

And so that is why it is nice to script an Accounts front-end based on a Staff table, storing Account Name in the Staff record.

This probably can be done server side in Server 10. But why are you wanting to do this?

Steven

This probably can be done server side in Server 10. But why are you wanting to do this?

Well, if you have any accounts management function in the user GUI you kind of need to see what accounts are already there before you try to create new ones.

Essentially I need to extend to normal users the ability to add accounts for other users to log in to the database. They should be able to see the active accounts list to determine user names that are already in the system.

I can certainly do that by maintaining a "users" database but I was hoping to directly query the database accoutns list and just build a list via a script.