Concatenate content of text field to a master record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to contenate products for all orders that a customer has from the
order level record to the customer level record. How can I do this MS Access
Database?Eg. Customer ABC has placed three orders namely Ord1, Ord2 and Ord3.
Ord1 was for products dining table, chair and coffee table. Ord2 was for sofa
and love seat. Ord2 was for a queen bed and mattress. I would like contenate
the product fields from the order records Ord1, Ord2 and Ord3 to the customer
level record for ABC to show the products dining table, chair, coffee table,
sofa, love seat, queen bed and mattress.
 
Edward,

The question is not "how", it's "should I?", and the answer is a
definite NO! Under no circumstances should you duplicate data (it
already exists in the order details table), nor should you put more than
one piece of data in a single field; both these practices are
incompatible with the whole notion of a normalized relational database.

There is certainly a better way to achieve what you are after; for
instance, if this is for a report, you retrieve all items ordered by
customers in a query joining the three tables (customers, orders, order
details) and group as required within the report design.

Post back with details of your current design and desired result, if you
need specific help.

HTH,
Nikos
 
Back
Top