G
Gary Stockton
I've currently got a product registration table that
contains a row for each product registered by a customer.
I would like to consolidate the customers into a single
table where they are only listed once as a single row. I
would like to relate the products they registered in a
separate table. There are 4900 records. The main table
has an Autonumber for each record. Is there a way of
breaking this data down while not losing the
relationship? If I list a customer once in the new table,
how do I maintain the relationship to the four or five
products they may have registered? I'd like to be able to
do this via queries vs. by hand if possible.
contains a row for each product registered by a customer.
I would like to consolidate the customers into a single
table where they are only listed once as a single row. I
would like to relate the products they registered in a
separate table. There are 4900 records. The main table
has an Autonumber for each record. Is there a way of
breaking this data down while not losing the
relationship? If I list a customer once in the new table,
how do I maintain the relationship to the four or five
products they may have registered? I'd like to be able to
do this via queries vs. by hand if possible.