Compare Data in Two Tables

[frankj]

I have a database in which survey data is entered twice (by coder A & B). Coder A's Form is linked to a table storing their data. Coder B's form is linked to a table storing their data. In every other way, the forms and data structures are identical.

What I need to do is set up a data validation routine. Once coder A has entered the data into their table - Coder B can enter data into their table. What I want to have happen (by what magic I do not know) is when Coder B enters in data for the second time - (on exit or the like) that data is compared to what Coder A entered. If they match - no problem. If they do not match, and message box pops up warning Coder B that what they entered does not match what Coder A entered. Just a warning - no big show. Just a nag to make sure they enter the data right.

If anyone can figure this out..and explain it for a newbie (sample code WAY welcome) I will be forever grateful!

[PianoMan64]

I have a database in which survey data is entered twice (by coder A & B). Coder A's Form is linked to a table storing their data. Coder B's form is linked to a table storing their data. In every other way, the forms and data structures are identical.

What I need to do is set up a data validation routine. Once coder A has entered the data into their table - Coder B can enter data into their table. What I want to have happen (by what magic I do not know) is when Coder B enters in data for the second time - (on exit or the like) that data is compared to what Coder A entered. If they match - no problem. If they do not match, and message box pops up warning Coder B that what they entered does not match what Coder A entered. Just a warning - no big show. Just a nag to make sure they enter the data right.

If anyone can figure this out..and explain it for a newbie (sample code WAY welcome) I will be forever grateful!

I guess my question is, do you have something between the two tables that the two users are entrying data into, that will be used as something to uniquly indentify the record that they are entering, so as to be able to find the information that user B is entrying after user A has entered their data?

This would be very import to establish, otherwise, if there is no match to the data, then what? do you want to display the message that it doesn't match?

Not sure what it is that you're trying to do.

Need more details,

Thanks,

Joe P.

[frankj]

Yes - there is a common table storing record ids. So Coder A has data that goes into their table. Coder B had data that goes into their table. What unites them is the subject ID. The primary key for each table may be different, but that subject ID is still associated with that record.