I am also new to Access but I think I understand what you are saying. What I would do if I were you would be to not combined the tables at all I would only keep the customer info in one table then only the product info in the second table.
I had this similar situation when I started dabling with access before I truly started to understand it. What you have done is put one to many fields in the product table you don't need the custName. I am trying to recreate what you are explaining in your msgs. In a new database here now. If you would like to take a look at the sample database I have designed for you let me know where to send and I will. In [email protected], G Costa <[EMAIL PROTECTED]> wrote: > > I will try once more to explain my dilemma. > > I have a Master Customer table (500 customers), the > fields in this table are Cust ID, Cust Name, principle > name, address, city, state, zip, email, website etc. > > There is another table called Products (17000 > customers), the fields in this table are Cust ID, Cust > Name, Product 1, 2, and 3. The product information is > designated with a yes or no. > > What I want to do is add the product columns that are > in the Products table to the 500 customers in the > Master. > > I have made a relationship between the two tables. I > have also added the Product fields to my Master. Now > I need to combine the product information into my > Master. > > Hope this information helps this time. I am ready to > give up and my employer is going to find out soon that > I don't know what I am doing. > > Thanks, > > Gloria > > --- Brett Collings <[EMAIL PROTECTED]> wrote: > > > Ahhh yes Gloria, the cruelest cut of all for a new > > Access developer > > is knowing Excel. > > > > So, start at the basics for us. > > - What is your database about (we've seen them all > > before) > > - What are your main data groups (ie Customers, > > Stock, Orders) > > - What is the job you have set out to do (ie maling > > list, stock > > inventory, sales records etc) > > > > See how we go from there > > \Brett > > > > > > > > At 01:16 25/08/06, you wrote: > > > > >Brett, > > > > > >I did respond and outline what it was I wanted to > > do, that is why I > > >asked again yesterday. Maybe my problem is the > > language in Access. > > >I am so used to using Excel. > > > > > >If you need me to outline by business case again I > > will. > > > > > >Gloria > > > > > >--- In [email protected], Brett Collings > > <bac@> wrote: > > > > > > > > Well to be honest, you tell us that you want to > > merge the products > > > > into your master table and I have to say that > > doesn't sound right > > >at > > > > all. That's why we were asking you to outline > > your data and what > > >the > > > > business case is. > > > > > > > > Combining your data is "a piece of cake" but I > > really suspect that > > > > it's not the way you think ... but I can't be > > sure of that until we > > > > get an idea of the detailed stuff. Part of what > > this questioning > > >is > > > > about is to ensure that you don't build a > > non-normalized database > > > > that will always cause issues as you continue to > > develop it. > > > > > > > > Brett > > > > > > > > > > > > > > > > At 06:43 24/08/06, you wrote: > > > > > > > > >I still haven't heard from anyone about this > > problem. Can anyone > > > > >help me please? > > > > > > > > > >G. > > > > > > > > > >--- In [email protected], "gcosta1010" > > <gcosta1010@> wrote: > > > > > > > > > > > > Brett, > > > > > > > > > > > > I am answering your questions below within > > your message. > > > > > > > > > > > > G. > > > > > > --- In [email protected], Brett > > Collings <bac@> wrote: > > > > > > > > > > > > > > G, > > > > > > > > > > > > > > This is really a piece of cake, we just > > need to reorganise the > > > > > > > approach to it. As I understand it > > > > > > > > > > > > > > - tblMaster has customer records > > > > > > > - tblProduct has a mixture of customerID's > > and Products > > > > > > > > > > > > > > The questions ... > > > > > > > - What is the structure (fields) of > > tblMaster? > > > > > > There are probably 12 fields in the Master, > > cust ID, Cust Name, > > > > > > address, email, website..etc. > > > > > > > > > > > > > - What is the structure (fields( of > > tblProducts? > > > > > > This table has cust ID, Cust Name, Product 1 > > (with yes or no), > > > > > > Product 2 & 3 with same yes no answer. > > > > > > > > > > > > > - Is there more than one Product per > > customer in tblProducts? > > > > > > Answered above. > > > > > > > > > > > > > - Are the other 16,500 records of 'old' > > customers? > > > > > > The Master has the top 500 Customer, the > > other 16,500 I do not > > >need > > > > > > > > > > > > > - What do you want to *do* with the > > information (please don't > > > > >tell > > > > > > us how you want to do it, just what) > > > > > > I want to merge the products of the 500 cust > > into my Master. > > > > > > > > > > > > > What you do *not* want to do ... > > > > > > > - Add the product code to your tblMaster > > YES > > > > > > > - Have Customer information in both table > > except CustomerID > > >YES > > > > > > > > > > > > I have added the three product columns to my > > Master to be ready > > >to > > > > > > merge the products into it from the Products > > table. > > > > > > > > > > > > You say this is a piece of cake, not for me > > it isn't. I hope > > >this > > > > > > helps clear up what I need to do. Thanks for > > your help. > > > > > > > > > > > > > So you can see why a little more info on > > your tables and what > > >is > > > > >in > > > > > > > them will be useful > > > > > > > > > > > > > > Brett > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >-- > > > > >No virus found in this incoming message. > > > > >Checked by AVG Free Edition. > > > > >Version: 7.1.405 / Virus Database: 268.11.3/423 > > - Release Date: > > >18/08/06 > > > > > > > > > > > > -- > > > > No virus found in this outgoing message. > > > > Checked by AVG Free Edition. > > > > Version: 7.1.405 / Virus Database: 268.11.3/423 > > - Release Date: > > >18/08/06 > > > > > > > > > > > > > > > > > > > > > > > > > > > >Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > >-- > > >Internal Virus Database is out-of-date. > > >Checked by AVG Free Edition. > > >Version: 7.1.405 / Virus Database: 268.11.3/423 - > > Release > === message truncated === > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
