In my limited banking experience I don't have a relationship directly
with a bank.

I have multiple bank accounts, at multiple banks. My bank accounts
are related to the bank, I am related to the bank account.

I see the structure as such:

Clients:
client_id
other attributes of clients

Banks:
bank_id
other attributes of banks

Bank_Accounts:
bank_account_id
bank_id
client_id
other attributes of bank_accounts

Cheers,
Jason Lepack

On Aug 15, 7:10 pm, cbayardo
wrote:
Hi, I have 2 tables, Banks and Clients. Each Client can have more than one
bank. What I want to find out, is do I create another table that has the
relationships Client/Bank. In other words, Client A went to Bank X and Bank
Y. Client B to Bank Y and Bank Z and Bank U. The clients table will change,
but the Banks table should stay the same. Is this just a simple add a query
or just create a form?

Thanks