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