On 16 Aug, 00:10, cbayardo wrote:
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.

Note that the relationship is usually between an account (check
account, savings account, mortgage account, loan account, etc) and one
or more legal persons (natural persons and organizations) who are the
holders of that account; the bank is an attribute of the account i.e.
no direct relationship between person and bank. While there's no
reason to abstract/simplify for your own purposes (and I don't know
what you purposes are) with a single Client/Bank relationship table
(a.k.a. junction table), if you ever need to model accounts then I
would advise you design them in now rather than have to retrofit them
later.

Jamie.

--