Creating a Contact Manager?

[Leo]

I am looking at creating an in-house contact manager program. It would be very basic and carry only information that pertains to our line of work.

The issue I have is how do I create security? I will have three to four salesmen inputting their own leads for record keeping. I want to create one table that works as a master list, but will not allow someone to see leads that are not their own.

Any Ideas?

 

[Rob.Mills]

I've done something very similar. I've attached a text file that explains how to setup user-level security. Then what I did was in the main table place a field called txtUser. From here I created a query that pulls all the fields from the main table and in the criteria for txtUser put:

CurrentUser()

You'll also have to setup your forms to automatically put the User id in each new record.

 

[Rob.Mills]

I've done something very similar. I've attached a text file that explains how to setup user-level security. Then what I did was in the main table place a field called txtUser. From here I created a query that pulls all the fields from the main table and in the criteria for txtUser put:

CurrentUser()

You'll also have to setup your forms to automatically put the User id in each new record.