Re: One view from two lists. A challenge?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bil Simser [MVP] (bsimser_at_shaw.ca)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 01:14:07 +0000

"Ian Morrish" <ian_morrish@hotmaildotcom> wrote in message
news:ian_morrish@hotmaildotcom:
> Can't turn down a challenge ;-)
> Is the Album a lookup field in the track list?

Yes.

> Given that compilation albums can have tracks from multiple artists have
> you
> considered a 3rd list containing artists?

Didn't want to make things too complicated at this point (and I'm not
using Albums and Tracks but rather internal names but the principle is
the same).

> A stored proc on the SQL server is probably the quickest way to go (but is
> unsupported, so this is what I will try first ;-)

Yeah, I really don't want to mess with SQL at all, ever. So some kind of
DVWP would be a good option. I considered building a web service that
yanked all the info in but that's sort of extreme for what is trying to
be accomplished here.

Thanks.