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 <*> 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/
