I have several related tables.
tblCustomerData has a field for Bank
tblBank has BankName and AccountType
tblBankAccountType has the type of accounts
A customer can have many Bank Accounts with different type of accounts
What's the best way to tie tblCustomerData, Bank to the various different bank accounts a customer can have such that I do not need a separtae field in tblCustomerData for each type of possible account?