The hyperlink address is an attribute of the party, so should be stored in a column in a Parties table. It can then be referenced anywhere in the database.
I would advise the column be of Short Text data type, named PartyLink say. The Hyperlink data type is more trouble than it is worth. The FollowHyperlink method of the Application object can then be used to open the link. Say, for example,
you have a form base on the Parties table, or more likely a query which includes the table, a button in the form would open the currently selected party's link in the default browser with the following code:
Application.FollowHyperlink Me.PartyLink
Whenever the value in the PartyLink column in a row in the Parties table is changed, the above code would open the new link.
Ken Sheridan, Stafford, England