As far as simple things are concerned yes and no.
Your sales people will need to have the layout that they view and edit data in keyed to a global field that contains their user name
then the layout shows related records compared to this global field
Depending on the number of child recrods etc you may need to make the key more specific and put a calculation field into the sales(other) record that combines more than one key such as customer ID and username.
This way the first key shows you all sales
the second key shows you all this specific customers sales.
So to explain my answer yes it can be done but its takes a bit of skill in defining keys and relationships. based on what exactly you want it to do.
For the admin level you need a separate layout which does not use the global key but looks at the records directly.
Clear as mud?
It really depends on what you consider easy. :)
You can set a field to auto enter account names. Since this is a data field, you can set it up that authorized users can then change this field by assigning a different account name to it. You can even put a list of account names in such a field if you want a group of users to have access.
Once you've set up that field, you can use Manage Accounts & Privileges (FMP 10 and earlier) or Manage Security (FMP 11) to set access privileges for records in each table of your database.
A simple expression that may serve here is:
Get ( AccountName ) = Table::AccountName
Where Table::AccountName auto enter's the user's account name when the record is created.
Once you have that set up, you can hide the denied access records with scripts that only find records that contain the user's account name in this field. In filemaker advanced, you can even modify the various menu options to omit these records when a find is performed or the Show all/Show Omitted options are selected.
Thank you for the replies.
I have to realize my limits. I am enjoying FMP very much, but have decided to search for a freelancer to handle the things I don't know how to do.