Ok I have a database and want users to be able to edit their own records but not others, so when they log in I would run a script to only view the users records i.e. do a search and restrict the output to only their records. if somehow they manage to view others records, I would like to Get the user name and tie it to a field created on the record when they create it which contains their user name.

I have actually done the field creation and the users name is inserted into the field upon creation, however I cannot seem to find a way to get the name of the "Current User" and use it to find only their records based on the field with the user name inserted when the record is created.

Do I need FMP Advanced to do this ? If so even the trial download does not work and just gives me the FM Pro download.

So will I have to upgrade to FMP Advanced to achieve this ?? seems a bit odd...

Edited January 6, 200818 yr by Guest

You can use Get(AccountName) to return the Account Name of the currently logged in account, which you can use:

- in your record-level restrictions in Manage -> Accounts and Privileges

- in scripted finds

by comparing against a field defined to autoenter Creation Account Name.

You don't need FMPA to do this.

When I do this a error is returned "This function cannot be found"

Get Account name does not appear in the functions list neither does Get Current user I typed in by hand but to no avail...

[color:red]Get ( AccountName ) is the very first Get Function. It's there. What version of the products are you using?

Steven