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.
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.