Hello all,


I'm trying to create hyperlinks to specific addresses for contacts in Access, but creating a hyperlink in Excel just gets me the link to the contact that's open at the time. So If I link to a name of a person in Excel (say cell H6) I get a person in Access. If I now put another name in cell H7 and create a hyperlink, I get the link to the same person as in cell H6.
Obviously you need to create a unique ID for every record, but how can this be done, if at all?
I appreciate your feedback. Best regards, Journstyx