NO Access On Records

[Colm Tourque]

I apologize I am brand new to File Maker (literally as of today) and desperately trying to get up to speed. I see there are several posts on this, but they all require some knowledge of the program. I have made a brand new database with 2 tables: 1 with employee id, and name fields

second with clientid, name fields, and employeeid

I am trying to allow the employee to login and see only his clients. I can do this...but I get the "No Access" on his records. I realize I need to write a script to turn this off, and can turn on the script writer. But don't know what to write or where to place it. Some help would be appreciated. Sorry more use to access, php, sql and this program is well confusing the heck out of me. Again any help woudl be appreciated but please keep it basic.

[Colm Tourque]

Hey I got the script to work (impressed myself really).

Now I'm looking for how to insert a script into a layout on open.

Already have all my layout made. So I'm searching the forum. If someone wants to hand me the answer here though I'll forgive you.

By the way used.

If (fieldname<> Get(accountname))

Omit Record

End If