Question Lock Record to User

[Screaminxpert]

Hi,

I was wondering if someone could advise me if it is possible to lock a record to a user and when another user requests a record from a table they are not displayed records locked to another user.

I am designing a Lead Distribution database and this is a fundemental part of the design.

I look forward to any assistance.

Thanks

 

[gemma-the-husky]

easiest way is to have a field in a record indicating to whom it is allocated

then have a query to find records either not allocated, or allocated to the active user.

 

[Screaminxpert]

So when the record is opened the field would be populated with the user?

 

[Screaminxpert]

OK, so I have created the Table and a form, I am now having trouble making the User Field populate with the current user when the record is opened in the form. Could someone advise on the easiest way of doing this?

 

[gemma-the-husky]

just have a field in the record for the user, and put this on the form you use (hidden if necessary)

when the first user reads this record, in the CURRENT event, set the "user" field to the current users name (if its blank)

currentuser will do if you use access security
environ("username") will give you the windows logon

 

[Screaminxpert]

Please forgive me,

I have absolutely no idea how to do what I am asking. I need the Field - User: to be set with the current users (windows login) user name.

The aim of all of this is for a sales agent to be able to request leads as they need them and to never be given the same lead twice in a 24 hour period or any lead already worked on by another agent in that 24 hours.

I presume this is going to need some complex VB coding and would reallty appreciate some help, if anyone wants to chat to me about this I am on msn david.hodgson@live.co.uk

Thanks