concatenating text fields

[looperboy]

is it possible to display text in a calculated field? Say you had a products table in which a customer had bought a number of products- could you run a crosstab query to collect all the products they had brought and display them as a list in one field?

 

[SteveR77]

Correct me if I am wrong but it sounds like you want to set up a one to many relationship. One order to many products that would in turn be related to one customer.

If that is true a good starting point would be the Northwinds sample database, and understanding how to build a main/sub form.

I hope this helps. If I am off track please let me know.

Steve

 

[looperboy]

thanks steve,

that sounds about right.

i'll have a proper look at the northwinds database, and get back in touch if there is a problem

stuart