Dear All,

I was wondering if you could help me.

I am looking for a some type of code that will only show per user a set of 50 records automatically generated by a button or any other mean to assign the above 50 records.

The tables are set out as follows:

JT Clients = Customer/Client Names only
JT Contacts = Contacts only at the second linked by client name, this could be changed.
JT Accounts = List of sales people each assinged a sales ID.

Other users should not be able to see other peoples records, I thought of using a temp table but was not sure how this would work as the data needs to be put back in to the main table (JT Clients and JT Contacts).

I thank you in advance and hope to be able to put this to bed very soon.

Kind Regards

Alastair

CAN ANYBODY HELP ON THE ABOVE TOPIC PLEASE :confused:

Have an AutoNumber field [ClientID] in the clients table rather than the name link. In the contacts table have the same named field [ClientID] just as a number and link on those and have the sales persons ID allocated to each contact.

Then make a table listing the sales people's ID and their network UserName, when they log on have the query behind the contacts form use their network name as a filter to only show the 50 records that they have their ID allocated to.

Col

Thank you very much for your help, and responding.

I will look into the suggestions given.

Regards


Alastair

Can i add the sales ID's automatically to the clients reference point.

anybody out there!