I have a database that multiple employees use to submit their expense reports. I'm trying to write script to only show the records for the employee who logs in:

Get (Account Name)

Find records: name=Account Name

Not sure the best way to do this, so an employee doesn't see everyone else's expenses?

Thx

Hi,

How about setting the 'find' script to run at startup? (File/File Options/then the Open/Close tab where you can set any script to run at startup or closedown).

That's what I'm trying to do, but can't figure our how to make a find request that searches based on get function? Here's my example:

Perform Find[Restore]

Find records when:

Employee name: Get(Account Name)

How do I insert functions or calculations in the find request criteria? It only appears to allow fixed values or boolean symbols?

Enter Find Mode []

Set Field [name; Get(AccountName)]

Perform Find []

To answer your question about Find, you can set fields in find mode by scripting (pseudo-code)

Go to Layout Find

Enter Find Mode

Set Field or Fields

Perform Find

Go to layout List View

However, protecting one user from seeing a record created or "belonging" to another user is typically handled by privilege set record access. For example, users can view a record if the AccountCreated field = Get (AccountName). This supposes that you have the AccountCreated field set to auotenter the Get(AccountName).

Thanks