I currently have a database (dadabik) that has 2 levels of user (admin and normal)
each user logs in, enters the info and can see only their entered info (We want to keep this option also).
admin can see all the different users entered info.
This db is based around salesman and installers.
The salesman logs in, enters his sales (which he can check back to see if the deal went through)
At the moment admin has to export each set of sales and email to each installer.
would this scenario below be possible with your software?
_________________________________________________________________________________________
Gayle is admin (admin user)
Ian is salesman (normal user)
Lee is installer (normal user)
Fields in db:
salesman < field type = drop down select)
installer < field type = drop down select)
salesman gets the sales and gives them to admin (Gayle).
She logs in and enters the sale selecting Ian as the salesman and Lee as the installer.
------------------------------------------------------------------------------------
What i would like to do
if Ian is selected as salesman, this record would show up when he logs in under his own username
and the same for Lee if he is selected as the installer.
______________________________________________________________________________________________________
This would then allow admin to simply select each salesman and installer and each day they would be able to see what jobs they have or (in the case of the salesman) how his sales are progressing.
Ill end my ramblings now

thanks very much