I have an Access database with two tables and a form.
The form is linked to one of the tables for data entry purposes.
LIVEDBwhich is a table of live customers' info.
LIVEDBINPUTform which inputs information into
CANCELLATIONDBwhich is just a table - when someone cancels, they are simple cut from
LIVEDBand pasted into
I have all sorts of rules that prevent duplicates in the
LIVEDBINPUT form, but I have recently encountered a problem: the
LIVEDBINPUT form is not preventing duplicates from the
CANCELLATIONDB table, only the
I want the form to prevent a telephone number being entered, if the telephone number already appears in either the
LIVEDB table OR the
If I could configure a message box to appear that states something like "this telephone number already exists in
CANCELLATIONDB", and then the option to take the user to that record or delete it, that would be ideal.
I have found loads of information about how to achieve this in multiple columns of one table, but I can't work out or find a way to prevent the duplicates from both tables i.e. for the form to prevent creating a duplicate that already exists in either of the two tables.