Concatonating Values - Many To One Relationship

[DJ100]

Hi,

Here goes . . . .

I have an order processing DB with several tables. One of these is Orders one is Lineitem. It is possible to have many Lineitem entries to one Order which are entered using a continuous subform. Each Lineitem has a shortcode.

What I would like to do is concatonate the shortcodes from lineitem in to a field in the Orders table.

Is this possible?

I know that one immediate problem is that I could possibly have an infinite number of Lineitem entries however over the last 3 years running the system the maximum number of lines on an order has been 6 and so even allowing for increases in lineitems (which is unlikely) I would be happy to limit this to 10.

Would be grateful for any help

DJ100

 

[KeithIT]

What is the purpose of concatenating them into one field? Wouldn't you put the line items into a table that linked them to an order?