Display content from different enteries from the same table

[gadflyjs]

I have two tables here, one contain the basc info of several items, said 10
items, and using an ID to identify them; the second table, store the records
related to those items at the first table, using a different id to identify
these records and linked the first table with the item ID. since there may be
more than one record for each items, so the second table has more entries,
said total 50 records.

What I want to do is, to make a query that show all 10 items, and followed
with all related records (combine together, separate with space).
Any thought?

Thanks in advance.

 

[Allen Browne]

Use a VBA function to concatenate the values form the related table into a
string.

For details, see the code in this article:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm