On Wed, 15 Aug 2007 16:10:00 -0700, 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

You need to add a table and also create a form. The new table should have
fields for the ClientID (a link to the clients table's primary key) and for
the BankID (a link to the banks table primary key), and any additional fields
for information pertaining to *this* client and *this* bank.

You can enter data into this table by using a Subform of either the Clients
form or the Banks form, whichever is more convenient (you can even do both).
For example, if you're centering on the client, you could have a Clients form
for entering client-specific data, with a subform based on ClientBanks (or
whatever you call this new table). Use the ClientID as the subform's Master
and Child Link Fields to automatically fill in the clientID, and put a Combo
Box on the subform based on the Banks table.

John W. Vinson [MVP]