Hi

I want to make a list on every active users on a given file.

The function should probably be something like: Get( ActiveAccounts)

But I can't find it.

I don't want to make a workaround. (Set value in field on login e.g.)

The FM Server retains a list on current users. It's a similar list I'm looking for.

Anyone got a clue ?

;-) Claus

No, there is no such function. I suppose it's a security risk.

I think your best bet is to have a User table where each record is one User, probably with the User's Privilege Set information. The Privilege Set info helps if you are doing automated account maintenance.

Anyway, if you have that table, you can create a value list of the account names, and from that, create a calc (or custom function) to return the value list items of account names:

GetAccountNames() =

ValueListItems( get( FileName ); "Accounts Value List" )