Solution
I've done this in quite a simple way...
I' added a text field on my Client table. Then from the form I made this into a hyperlink via properties.
You have use admin mode to edit the hyperlink, which does have to be done for each client but you only need to set this once. Each client's hyperlink location is then stored in the text box / field on the Client table, so the hyperlink takes you to a specific location for each client.
Hope this helps