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 > <[EMAIL PROTECTED]> 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/
