I am building a project that uses an Access 97 database as the background table...

The Managers in my call center will be inputting scores for their respective staff into the access database...The way it goes is that for one representative, their could be up to 3 Managers providing scores every month...

So I needed the database to hold just one record per representative, rather than 3 seperate records...so I created the Access form, and limited the editing process....I also inserted parameters within the query that the form is bound to, so that when the Managers open the form it will prompt them for the rep's specific ID...

I thought this way once a Manager is on the record, if another Manager cam in to add scores for the same rep, they would have to wait till the record becomes available...

Well her is the snag, I was testing it, and found that all 3 Managers could very well open the form at the same time, and their could be 3 seperate records again???? I know the probability is high , but just the chance could screw up the results in my vb project...

SO if anyone can think of any other options, please pass them along ....I need to iron this out fairly quick..

THANK YOU!