How to merge data from related records into one string

[item67]

I have a table called "Article" which has an relation with several other tables. One of the tables is called "Size" and an other is called "Colors". Each Article has a minimum of 1 and a maximum of 10 "sizes" and/or "colors". One of the fields in a "size" record is a field that contains a combination of two letters.



For example:
Article "100" has 3 related sizes with the lettercodes: "AA", "AB" and "AC" and two colors "red" and "blue"
Article "101" has 6 related sizes with the lettercodes: "AA", "BB", "CC", "DD", "EE" and "FF" and two colors "red" and "black"

Now I want to create an overview that has the following result:
100 Red AA-AB-AC
100 Blue AA-AB-AC
101 Red AA-BB-CC-DD-EE-FF
101 Black AA-BB-CC-DD-EE-FF

For this overview I need to merge the data from lettercodes for into one string. Is this possible?

[ranman256]

tbl1.color & " " & tbl2.size

[item67]

Thnx for your response. I did some further research on the internet and I found "fconcatfld function" which does exactly what I want.