Conditional Formatting - field data matching another table field content
Hi! I hope you can help
Database contains the following tables: EUSANCTIONS and PAYMENTSOUT -
Table: EUSANCTIONS contains fields such as NAME_FIRST, NAME_LAST etc...
In the Table: PAYMENTSOUT, field BENEFICIARY_NAME I would like to conditionally format to alert me if a name entered here matches a name in the EUSANCTIONS table.
Any clues? Thanks!