Hyperlink

[KeisukeNozaki]

Is there a way to hyperlink a field from a related table in ArcGIS Desktop 10?
I cannot join the table because it is one to many relationship.
I prefer field based hyperlink, not dynamic hyperlink, because there are thousands of features.

[MathieuCain]

A possible way around it is to create a new feature layer where you join the attribute table of your layer to the hyperlinks table, in essence creating new features for each hyperlink record. Some features will overlap since you have many hyperlinks per feature. You could then make your new hyperlink layer features transparent in your map. When a user uses the hyperlinks tool they will only see the blue feature layers, which when selected will give you a list of which hyperlinks at that particular location. Hopefully you get the gist.

[RichardFairhurst]

A possible way around it is to create a new feature layer where you join the attribute table of your layer to the hyperlinks table, in essence creating new features for each hyperlink record. Some features will overlap since you have many hyperlinks per feature. You could then make your new hyperlink layer features transparent in your map. When a user uses the hyperlinks tool they will only see the blue feature layers, which when selected will give you a list of which hyperlinks at that particular location. Hopefully you get the gist.

This won't work because of the one-to-many relationship.  You could use the Make Query Table tool to handle the join instead.  It will multiply the feature geometry for as many table records that exist.  Read the help for it here.

A relate works with the Identify tool to access the hyperlink fields if you enable all hyperlinks in the options of ArcMap.  You have to expand the relate tree to get at the hyperlink field, so it is a few clicks, but the records can be sorted on a Display field, which I like better than the hyperlink tool.

[KeisukeNozaki]

How do you enable hyperlink fields in layer properties?
Fields in the related table are not listed in the drop down menu.

This won't work because of the one-to-many relationship.  You could use the Make Query Table tool to handle the join instead.  It will multiply the feature geometry for as many table records that exist.  Read the help for it here.

A relate works with the Identify tool to access the hyperlink fields if you enable all hyperlinks in the options of ArcMap.  You have to expand the relate tree to get at the hyperlink field, so it is a few clicks, but the records can be sorted on a Display field, which I like better than the hyperlink tool.

[RichardFairhurst]

How do you enable hyperlink fields in layer properties?
Fields in the related table are not listed in the drop down menu.

You must have ArcGIS 9.3 (maybe 9.2) or better.  Access the ArcMap Option under the Customize tab and check the item shown in the first image to make any available hyperlink active in the Identify tool.  Create your relate.  Make sure the Display field expression of your layer creates a meaningful label (at ArcGIS 10 you can build a label from many fields just like in the Label Tab of the layer).  If you enable record sorting in the Identify tool the features will be listed alphabetically based on the label expression you built.

Now when you click the Identify tool, make sure that the layer with the relate is an Identify target.  The features of the layer will have a tree expander as shown in the upper half of the dialog of the second attached image.  Expand the tree two levels to get to the related table records.  In this case there are 4 related table records to the feature.  Click on one of the related records to access its field list.

Any fields that contain a useable hyperlink in the related table will be active and can be clicked to launch the hyperlink as shown in the lower half of the dialog in the second attached image.  I have only one hyperlink field in my related records in this example, but I could have made every field a hyperlink in my related table if I had wanted it to be that way.  (I just noticed I cut off the little lightning bolt that appeared on the right hand side of the text in the field with the hyperlink, but when I first captured the image the hyperlink lightning bolt was there).

[KeisukeNozaki]

It worked!
Thank you very much for your help.

[DuccioNotari]

I didn't manage to get this working! the "lightning bolt" of the hyperlinks doesn't even light on! I can see the correct field in the identify window but it isn't highlighted and it doesn't work.. the field is text type, I am storing relative path names so I did wrote the hyperlink base in the map document properties, the arcmap options are the same of rfairhur24's images..
what did I do wrong?
please help!

[RichardFairhurst]

I didn't manage to get this working! the "lightning bolt" of the hyperlinks doesn't even light on! I can see the correct field in the identify window but it isn't highlighted and it doesn't work.. the field is text type, I am storing relative path names so I did wrote the hyperlink base in the map document properties, the arcmap options are the same of rfairhur24's images..
what did I do wrong?
please help!

I don't know if Relative Paths works for hyperlinks.  As far as I know the URL has to make sense to the browser or application apart from any settings in ArcMap.  So you should try pasting the link directly into the application or browser and see if it works.  Adjust it until it does work.  I always put the full URL or File path, although I try to use domain names rather than mapped drive letters to try to keep the link from breaking when servers retire and to make it more universal across computers in my domain.

[DuccioNotari]

I don't know if Relative Paths works for hyperlinks.  As far as I know the URL has to make sense to the browser or application apart from any settings in ArcMap.  So you should try pasting the link directly into the application or browser and see if it works.  Adjust it until it does work.  I always put the full URL or File path, although I try to use domain names rather than mapped drive letters to try to keep the link from breaking when servers retire and to make it more universal across computers in my domain.

it's right! the full path works! I don't have URLs but only files and it would be useful to store them with relative paths, so I can share the mxd without big problems!
here explains the methods:
http://support.esri.com/en/knowledgebase/techarticles/detail/20626
but still not working..

[DuccioNotari]

it works with paths relative to the mxd location..
but if in the Map Document Properties I've decided a different "Hyperlink base"... why it doesn't use it?