single query row display multiple subrecords?

[vientito]

I have a recordset which contains a subrecord linked by one-to-many relationship as depicted below:





My question is as follows: I can construct a query which consists of rows that I can put constraint to show only one single CatType at a time.

What I really want to do is to be able to construct a query table where one single row will show all the subrecord fields on one line, meaning that they are put side by side on neighbouring columns. I do not want to show duplicate itemID to account for all the rows in the subrecord. I would like one item ID having one row that embeds two columns each correspond to every single CatType in the subrecord.

Is that at all possible to do?

[ranman256]

Yes, build a crosstab query. (use the wizard) Make that your subform query.