Hyperlink from Access Database

[SHIPP]

I've worked my way through programmatically having a link appear in my Access
Database on my website to another web page. However the link appears as...

http://www.horseshowscentral.com/caqhea.htm

Is there a way, programmatically, to change what appears on my website to
something like More Info from Caqhea and then have it go to the link
identified above?

 

[Andrew Murray]

Yes,

<a href="<% ::yourfield::%>">More Info</a>

Within the Results Area (yellow borders), replace what would normally be an
URL to the page in the "href" section with the name of the field from your
database.

(as demonstrated above).

The syntax is probably not entirely correct.

If you want different wording for each link, add a field to the database
called "text_link" and in the DB, put the text you want to show as the
hyperlink, which is linked to the other field containing the URL to the
page.

like: <a href=<% ::yourfield::%>"><%::yourlink::%></a>

Instead of writing it in the HTML/ASP (which you can't do since FP will
change the code back) do the above within the results wizard and/or the
Hyperlinks Properties, then choose "Parameters".

You can click a field name, go to hyperlink properties, then to parameters
and choose the field that contains the text (for the link) and the field
that contains the URL .

I hope that makes sense, it is explained as best that I understand it.