Here is a little problem I’ve been having in ArcMap: When I create a geology map, I am using a geodatabase with the Geologic Atlas of Texas (GAT_250K-es.mdb) that contains digitized rock units and faults. This allows me to create great looking geology maps all over the State of Texas. A second geodatabase (GAT_Rockunit_Tables.mdb) includes additional attributes of the units and formations included in the first one, such as a description of the lithology.
What I would like to do but have been unable to figure out up to this point is to plot and label my geologic units on a map using MDB#1 but then label them in the legend using an attribute from MDB#2. It’s easy to join the two tables. But I can’t figure out, how to label the legend without also changing the labeling on the map. On the symbology table of the rock unit layer, you can enter a description for each record which then appears in the legend behind the actual label (in italics). I would be happy doing that if it weren’t such a pain to manually enter all these descriptions. Is there a shortcut to this ? I can’t seem to find it.