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