Changing view criteria based on user?
I have an public form that i have multiple sales people submitting sales information to me from. I want these sales people to be able to view all records that they have submitted. I do not want them to be able to view other sales persons records.
Is there a way using html views to have them input a user name and password. If it is correct, view all records that they have submitted?
I figure they submit a logon form that then does an if then and determines if it should forward them to the view that is based on the user name that they provided. This same user name has already been entered in when they submited a sale.