I realise I am being really stupid here but....

I have a form layout based on a table and a list layout based on the same table. One of the fields is the staff assigned to this record. These staff names are the same as the account names used when logging into filemaker. I have created a button to go from the form layout to the list layout but I only want the user to see their own records. So the script on the button does the following things:

1. It puts the current account name of the logged on user into a global field

2. It opens the list layout

3. It performs a find where the account name global field is the same as the staff name field.

but I can not work out how to do a perform find (Step 3) where it matches the information between two fields within the same record.

Can anyone help

John

PS I have tried using the account setting and this locks out the user from records that are not his but does not hide them and the list report looks messy and makes searching for non locked our records difficult.

1. It puts the current account name of the logged on user into a global field

2. It opens the list layout

3. It performs a find where the account name global field is the same as the staff name field.

It's not too obvious why you need a global field for it in the first place ... when:

Enter Find Mode [  ] 

Set Field [ Untitled::StaffName; Get ( UserName ) ] 

Perform Find [  ] 

...in my humble opinion should do??

--sd

Thank you, with one small change it worked like a dream. I changed Get(UserName) to Get(AccountName).

Many thanks

How clunky have you honestly expected this tool to be??

--sd