One-To-Many Relationship On One Row

[Guest]

I want to make a query from two tables that have a one-to-many relationship.
Each record in the "one" table is limited to 8 records in the "many" table.
Each "many" record has a sequence field that is numbered from 1-8. Is it
possible to make the query display the "many" records on the same row as the
"one" record but in seperate fields according to the sequence field (e.g.
Many1, Many2, Many3, etc.)? Not every "one" record has 8 corresponding "many"
records.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Thanks, but I wanted to seperate the "many" records into 8 individual fields
rather than concatenate them all into one.

 

[Pat Hartman]

Try using a CrossTab query. You can use the ColumnHeaders property if you
need to force 8 columns all the time.

 

[Andreas]

Sounds Like a crosstab query, I think.

Regards,
Andreas