Hi All,
A few years ago I set up a database for tracking and controlling equipment from last use all the way through to the original purchase order (hyperlink). A few months ago I decided to sort the database alphabetically when not filtered, rather than the order the items were entered. Since then I have entered a few hundred more items. Today I noticed the hyperlinks are totally screwed up, its as if it has sorted all the columns apart from the column containing the hyperlinks . So my question is- does anybody know how to resolve this? Is there away way to revert the data back to the order it was entered in the hope it would correct the hyperlinks? I have 3000+ items, I really don't want to have to go through and correct each one.
Thanks in advance for your help.