Using Dreamwever (ASP VBScript) and Access.
I have a database containing leads that contractors will log into. I have DW's authentication setup where I have a Contractors table containing usernames and passwords (and a field for the custom access level).
All leads have one contractor assigned to it.
Now I'd like to accomplish the following:
1. Be able to display the username of the contractor that is logged in.
2. Only show (filter) the leads for the logged-in contractor (I do not want Contractor A to see the leads of Contractor B).
What would I have to do to accomplish both objectives?