I have a form in datasheet view and a field for entering the account number of a client. I'm looking for a way to double check to make sure the account numer is assigned to that specific client. There are different account numbers for each client depending on the type of account so it would have to check:
1: the account is assigned to the correct client
2: the account number entered is for the correct account type
Any suggestions?