G,
This si 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?
- What is the structure (fields( of tblProducts?
- Is there more than one Product per customer in tblProducts?
- Are the other 16,500 records of 'old' customers?
- What do you want to *do* with the information (please don't tell us
how you want to do it, just what)
What you do *not* want to do ...
- Add the product code to your tblMaster
- Have Customer information in both table except CustomerID
- Have Product information in both tables except, only in tblProduct
So you can see why a little more info on your tables and what is in
them will be useful
Brett
At 08:49 18/08/06, you wrote:
>Hi,
>
>I am hoping someone can help me. I have a Master Table that has 500
>records of customers. There is a new table that has 17,000 customer
>records showing three fields of products with a yes/no indicating if
>that customer has that product. I need to add the 500 customers
>products that are shown on the New Table to the Master table for those
>500 customers. Don't care about the 16,500 other customer in the new
>table. Both tables have the Key of CustNum. I have created a
>relationship between the two tables but that is as far as I have gone.
>I have spent too much time trying to research how to do this in my MS
>Access 2002 manual and on the web.
>
>If you need me to make this clearer I can try.
>
>Thanks,
>
>G.
>
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.405 / Virus Database: 268.11.0/420 - Release Date: 16/08/06
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.0/420 - Release Date: 16/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/
