Solved

SharePoint 2007 Look up list

Posted on 2013-05-22
13
466 Views
Last Modified: 2013-08-21
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
Comment
Question by:sharepoint2013
  • 6
  • 4
  • 2
13 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39186759
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
 

Author Comment

by:sharepoint2013
ID: 39187038
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
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39187104
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 5

Accepted Solution

by:
manojce earned 500 total points
ID: 39189994
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
 

Author Comment

by:sharepoint2013
ID: 39193329
Thanks - is there a multi-hyperlink field?
0
 
LVL 5

Expert Comment

by:manojce
ID: 39193922
no, but you can use Multiple Rich Textbox field.
0
 

Author Comment

by:sharepoint2013
ID: 39219607
Ok, basically I need it such that when that item is selected

it will show a column 'hyperlink' that will contain multiple hyperlinks.
0
 

Author Comment

by:sharepoint2013
ID: 39352538
Any one can assist?
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39352885
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
 

Author Comment

by:sharepoint2013
ID: 39422623
@teylyn thanks i created the DVWP, what do i do next?
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39422934
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
 

Author Comment

by:sharepoint2013
ID: 39423948
Ok, thanks will try this weekend and post the code here.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question