Is there a way to concatenate Sales Details?

[markmarko]

With the scenerio of tblSalesOrders and tblSalesDetails (with fields Product
and Quantity), I'd like to create a Form that would be able to concatenate a
given sales order's SalesDetails into a single control.

So, for instance, a sales order has the following details:
ProductA
ProductD
ProductF

I'd like to be able to, in a continuous form, list each Sales Order, and on
each record have a field that would read "ProductA, ProductD, ProductF"

Any theories on how to accomplish this?

 

[Marshall Barton]

With the scenerio of tblSalesOrders and tblSalesDetails (with fields Product
and Quantity), I'd like to create a Form that would be able to concatenate a
given sales order's SalesDetails into a single control.

So, for instance, a sales order has the following details:
ProductA
ProductD
ProductF

I'd like to be able to, in a continuous form, list each Sales Order, and on
each record have a field that would read "ProductA, ProductD, ProductF"

You need a function to do that. There's a good one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[markmarko]

Ahh, that looks like it will do the trick. Thank you very much!