Click here - (need url from one table to another)

I am setting up a notification in the table called Reservations. In my custom message, I want to show: Click here (and this would take you to table called Customer Non Renewal and the form number is 1...