Multiple query fields into one string on web page

[taylorantone]

I used Front Page to pull data from a query onto the web. Everything works fine EXCEPT for the many-to-many relationship I have set up.

It pulls the first 3 fields from tblDVD just fine, then it's set to pull the many-to-many part (the genres) from the other table. The same movie is listed for every genre it belongs to.

What I want to do is have the results only have one movie per record, and consolidate the genres into the Genre field like this (Crime, Drama, Comedy). I don't even need the commas.

I'm also going to need to set up a search box later so that you can browse by genre, but I'll cross that bridge when I come to it.

Is this possible and not-too-terribly difficult?

Here's a link to what I'm talking about:

http://oneant.dyndns.org/dvdlist/dvdlistforwebbytitle.asp

 

[taylorantone]

Wow! I didn't think it was that hard.