• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

SharePoint 2007 Look up list

Hi experts!

I have a list of category names...

Cat1 (ID = 5)
Cat2 (ID = 6)
Cat3 (ID = 7)

I created a second list that has a field called Category which is a lookup from the above list. After i created the lookup... this field for example

Cat1 has a automatic hyperlink linked to the dispform.aspx?ID=5

I do not wish to link it to dispform.aspx?ID=5... I wish to link it to cat1.aspx, which is a hyperlink in another column named 'hyperlink'

How do I do this?
0
sharepoint2013
Asked:
sharepoint2013
  • 6
  • 4
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

A lookup field in the list view web part will by default link back to the list item of the lookup list.

If you don't want the out of the box presentation in the list view web part, you  will need to convert it to a Data View Web Part, where you can customize what the column's link target is.

It's a bit hard to tell what you want to achieve without more context.

cheers, teylyn
0
 
sharepoint2013Author Commented:
Can it lookup to the list 'Category' and show the hyperlink column.

This doesn't appear to be selectable in the lookup field choices
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Again:

the list view web part will link to the item in the lookup list. That is the default out-of-the-box behaviour.

If you want to show something different instead, you will need to replace the list view web part with a Data View Web Part, which you can configure to your needs.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
manojceCommented:
Hi SharePoint2013,

You can also created on SPD workflow which run every time Item Added & Updated & update your custom hyperlink field which contains Category column name.
Steps:
1. Create custom column which is hyperlink.
2. Create SPD workflow & and add Field update action.
3. Apply logic for field update for Category name.aspx.

Let me know if any issue.

Thanks
0
 
sharepoint2013Author Commented:
Thanks - is there a multi-hyperlink field?
0
 
manojceCommented:
no, but you can use Multiple Rich Textbox field.
0
 
sharepoint2013Author Commented:
Ok, basically I need it such that when that item is selected

it will show a column 'hyperlink' that will contain multiple hyperlinks.
0
 
sharepoint2013Author Commented:
Any one can assist?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Have you tried a DVWP as I suggested above? Did you run into any issues? If you don't respond to suggestions, it's really, really hard to help.
0
 
sharepoint2013Author Commented:
@teylyn thanks i created the DVWP, what do i do next?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Edit the DVWP in SharePoint Designer and add the column with the link to it.

This is just one short sentence, but it required a bit of a learning curve with regards to the structure of a DVWP and how it all works. As I said before, it's a little hard to help without more information.

- What is the name of the hyperlink column?
- Which columns did you include in the DVWP?
- Post the code of the DVWP for inspection
- Provide more information about the columns you want to show and how you want them to display.
0
 
sharepoint2013Author Commented:
Ok, thanks will try this weekend and post the code here.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 6
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now