You should have a column in the database for the link text and a form field on the Insert page to enter the link.
you then need to edit the insert record behavior and bind the column in the database to the form element on the page.
then on the page that shows the link, you can add the column binding inside the a tag:
<a href="<?php echo($row_recordsetName['ColumnName']); ?>"><?php echo($row_recordsetName['ColumnName']); ?></a>
if you continue to have problems, send a copy of the pages.