I am writing a database in access xp and need some help.

I have a list of users that all long in to the database using passwords, what i need to do is to assign a user changerable number of customer to each person.

I so far have a tblPreferences table this is updated by a form.

So i simple terms.

User Name = A. Lane Number of records (Customers) 50
Number of records should be linked to a table JT Clients and display 50 customers with contacts that are held in a table JT Contacts.

These customers once assinged should not be seen by any other users.

If anybody can help with examples i would be most greatful, i am new to this forum and hope to be helping others soon.

Alastair Lane.

If the other message was unclear, ask me to clarify

This post (http://www.access-programmers.co.uk/forums/showthread.php?postid=346110#post346110) may be of interest to you.

When you say "should not be seen" do you mean "must not be visible to"?

It would be easier to prevent them from viewing other records than to stop them. Which is it you need to do ?

preventing the users from see would be fine.

It is for a call centre, so each user should not phone the same customer in that day or week.

Thank you very much will look at the link.

Alastair