I'm working on a simple Sales Leads Contact database and am wondering if I can accomplish the following with DBMan SQL.

a) There are a couple of users in the company, all of whom will be entering new Sales Leads into the database. Users need to be able to add / edit / delete each others records.
b) One of the fields in the primary table containing contact info is "SalesRepID," which will be joined to another table (SalesRep) for look-up purposes. A sales rep is manually assigned (linked) to a record when it is entered.

So far, easy enough. However, they would like their Sales Reps to be able to login to the system, but ONLY see records that have been assigned to them. Can I accomplish this? If so, how would I create this kind of restriction? And where would I store the SalesRep login details? In the standard Users table, or by using extra fields in the SalesRep table I'm creating for lookup purposes?

Thanks -