Brett, I am answering your questions below within your message.
G. --- In [email protected], Brett Collings <[EMAIL PROTECTED]> 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/
