Hi. Thanks for all that will respond to this post

I have a small program to design for a company.

They have thier staff in different places and they engage in nation wide postings of their staff sometimes.

I designed a table with the following features:

1. EmployeeNumber

2. LocationPostedTo

3. Name

Note: their are other information but what is applicable for my question is what I state here.

Please, I want some body to direct me on what to do on the form I created concerning this table.

This is my challenge

1. I call up the employee number though a combo box I designed. It looks through the and apply in the employee name.

2. I call up the LocationPostedTo combo box and pick the new location the employee is to be posted to.

Now, I want that before the column is updated, the form should look through the table and check whether this employee has been posted to such location before, and if yes, it should pop up telling me that this employee has been posted to such place before, therefore cannot be posted to such a place again.

I hope I make myself understood.

Thanks