I am trying to figure out the best way to restrict users from viewing records not belonging to them.

I have created a login (per user) that corresponds to the field name

Example:

Field "NAME"

Records 1-1000 contain "NAME" "John Doe" so 1000 records are viewable by John Doe

Field "NAME"

Records 1001-2000 contain "NAME" Jane Doe" so 1000 records are viewable by Jane Doe (and not John Doe).. this would continue on per login.

What is the best way to restrict the viewing of records based on this strategy?? Any and all help would be apppreciated thank you.

Using Filemaker 7 Pro to try and create this rule.

Edited July 12, 200619 yr by Guest

Each user has an account and are associated with a Privilege Set.

Based upon the Get(PrivilegeSetName) or Get(ExtendedPrivileges) when the user logs

will determine if they can or cannot see certain records.

Such as John can only see records that are "open" and Jane can only see Records that are "paid"

This may point you in the right direction

http://filemaker.com/downloads/pdf/techbrief_security.pdf