Multiple records in one field

[Guest]

Hi all,

I have a difficult problem:
I have two tables, in 1 table there are my customers and in the other table
there are my products that my customers have.
For example:
Customer 1
Product A
Product B
Product C
Customer 2
Product B
Product D
Product E
etc.

Yet, I will make a query that do the following:

Customer 1 have the following products: Product A, Product B and Product C.

Is that possible?
If yes, can you send me an example?

Thanks

 

[JohnFol]

You need 3 tables,

Customers (ID = "1", Name = "Mr Joe Bloggs")
Products (ID = "1", Product = "Spam Fritters")
CustomerProducts (CustomerID = "1", ProductID = "1")

Have a look at the nWind sample MDB for many to many relationship examples.