Return Linked Lookup Values in a DataView

I'm trying to access information behind a lookup field in order to render as
a URL. In this case I have a list which has a lookup field to a document
library. When putting a dataview on to a web page the value that is
returned is the title of the document in the document library. I'm looking
for the URL to that page instead of the title. Does anyone know how to get
that information within the context of a dataview?

Thanks!
Colin

Mike
Tue Jan 06 02:50:50 CST 2004

I'm a bit confused (first lookup field then dataview) but it's perhaps
because when I write "dataview" it is always in connection with Front Page
2003's Data View.

Using that you can go straight to the list and define exactly which fields
you want to be visible on your page. The problem might however be with the
form of the URL (i.e. it will probably not be full path and the assumptions
about the initial part of the URL may be incorrect - it's certainly a
problem I've had when using FP Data View and a Database Table from another
server). I used to use ASP scripts accessing the STS/WSS database where I
could create the full URL from what was stored - you could still do that of
course (and shove it in a suitable web part).

Let me know if I missed the point of this question.....

Mike Walsh, Helsinki, Finland
WSS FAQ at wss.collutions.com
Please reply to the newsgroup

"Colin Bowern" <colin.bowern@nospam.indimensions.com> wrote in message
news:OgVkHl60DHA.2676@tk2msftngp13.phx.gbl...
> I'm trying to access information behind a lookup field in order to render
as
> a URL. In this case I have a list which has a lookup field to a document
> library. When putting a dataview on to a web page the value that is
> returned is the title of the document in the document library. I'm
looking
> for the URL to that page instead of the title. Does anyone know how to
get
> that information within the context of a dataview?
>
> Thanks!
> Colin
>
>