I have two databases in sql 2005
there is one table in each database called tbl200
this table has 2 fields called invoice no ,and supplier no
when the user enters an invoice in any of the two tables through a vb form I want the system to check whether this invoice number for this supplier already exists in any of the two databases or not.

How can I achieve that ?

Many thanks

Sandra
gonewild at muchomail.com