We're looking to create a validation table to restrict certain Expense Types with our Accounts. We currently have about 29 Expense Types (ID1) and Over 200 accounts (ID2). We know of specific combinations we'd like to restrict at first, but leave the rest open so that anyone can choose any account for the remaining expense types we aren't restricting. Is there a way to reference some wild card like * or % so that this can remain open? Or does every ID require every combination of values?
Example:
ID1 ID2
Safety Supplies - Other 64400
Entertainment Any?
