I'm trying to find a way to transpose records of a many-to-many relationship in one table on the row of another table. You can do it with a nested query but my thinking is that it's either slow (when the thousands of records populate the database) or there is another way to do it based on database design that wouldn't be such a bitch to deal with. I'm only rolling with Access at the moment so my ability to create a stored procedure to do it isn't there (You could right one to aggregate concat the columns).

Also I'm trying to figuring out a way to return only records in the right column that match three particular records in the left column (through the junction table).
So Table 1 has in a column 1, 2, 3, 4, 5 and Table two column has Record A and it matches 1, 2, 3 through a junction table and Record B matches 2, 3. I'd want to return Record A only and have the row as 1,2,3, Record A optimally but just returning Record 1 when the column is 1,2, and 3 would be nice.

9/1/2006 5:51:21 PM