Thread: Two tables
View Single Post
  #1  
Old August 16th, 2007, 12:10 AM posted to microsoft.public.access.tablesdbdesign
cbayardo
external usenet poster
 
Posts: 28
Default Two tables

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