Ok I have a nice login script now...

However I would like to do a seacrch on login to return only those files which are the users own files (unless admin of course).

So that the user does not see any "Access Denied" records.

this is proving tricky for me.

I have a field that is filled with the users user name on record creation and this is a hidden field so I would use that this field is called "creator"...

anyway thanks for any help anyone in advance.....

Hi Red,

Did you try as I suggested in this thread?

http://fmforums.com/forum/showtopic.php?tid/192394/post/277522/#277522

If you had problems with it, let me know I will see what I can do to help. If I can't help you then I'm sure someone else here will step in

Michael

Simply do a search on some value known to be in every record. The result will filter out those records the user [color:red]is not supposed to see while returning all the records the user is allowed to see.

Steven

If this is the first time someone logs in they will not have any records and and as such will get an error...

Could a script be used to create a record and put their user name in the correct field...

so >>>

the flow of the script would be if

count = 0 (count is the count of fields with their name in)

Create record .. insert [userName] into field "creator"

then do another find>>>>

Is that silly or would it work....

Trap for that error--namely 0 found count--and branch your script to do whatever you want to do.

Steven