Filemaker Solution 1

[dswett]

Hey everyone,
I am in the process of making a database on Filemaker Pro 7 on IWP. I have setup accounts/priveleges and what I want to do is on startup, perform a search for the accountname that was entered (there is a field that matches each accountname). I have tried many things in my startup script, but nothing seems to work (go to record needs a record number and find mode won't recognize Get ( Accountname ) as a variable. There are multiple records for each accountname and so after I find out how to get the user to the correct record, I can limit privileges to records only with their accountname in that field. Thanks for the help!

-dswett

 

[AndyGaunt]

Hi -

If you wish to find only those records created by that user, you could try the following

Set Error Capture [on]
# The set error capture will stop the find displaying an error message if no records are found
Enter Find Mode [turn off the pause option]
Set Field [Your table::your field, Get(AccountName)]
Perform Find
# Continue your script here. You may want to trap for no records found
If [ Get (LastERror) = 401]
  # No records are found. Perform task here for no records found
End If

HTH

Andy Gaunt

 

[dswett]

Wonderful, works perfectly! Thanks!