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?