Yes it is possible.

Declare a boolean, populate your two tables. If the record in table A is found in Table B set the boolean to true. Then use a messagebox to tell the user that the record is already in table B.