|
Home > Archive > MS Access and Internet > October 2005 > Hyperlink from "Results Table"'s filed to a full discreption
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Hyperlink from "Results Table"'s filed to a full discreption
|
|
| RDARDARI 2005-10-27, 8:31 am |
| Hello, I'm using FrontPage and MS Access on the Internet to do the following.
I have a web page that displays the "Results" of a Database Querey. However
the "Results" table will be displaying only few fields of the record. I like
to have a Hyperlink field in every record that when it is clicked on will
display a new web page with all the fields in that particular record. For
example my "Results" table will be showing the Data of following fields:
"Business Name", "Business Type" and "More Info" , like "The Dollar Place",
"Thrift shop" and "More Info" I like to have a Hyper link to "More Info"
field that when it is clicked on a new web page will open to show the
detailed information about the "Thrift Shop" like "Address" and "Phone
Number" etc... Can you help me please, thank you.
| |
| Dave Barnes 2005-10-27, 8:31 am |
| There are several ways to do this, aren't their always, you can basically do
either
1. supply all of the info to the results page and only display the short
list of fields that you want the punters to see. When they click on the more
info page, you could then pass all of the fields to that page and it could
then display them.
2. supply only the fields you wish to display and a unique record ID to the
results page. You can then pass only the ID to the details page and get the
page to do a lookup of the database for the record details that you wish to
display on that page.
Option 1 has a single database access, but returns more data. If you have
relatively few records this will be fine, but if you are returning hundreds
of records this would potentially cause a problem for the user, as it could
use up a lot of bandwidth and memory on their machine to send and store the
details.
Options 2 takes two database reads, but only for the details that they want
to see.
So the hyperlink would look something like <a
href="details.asp?code=1234">More Details</a>
You would obviously have to build the hyperlink up in code for each record
so that each row of your table had the appropriate code number.
Personally, I'd go for option 2.
good luck.
"RDARDARI" < RDARDARI@discussions
.microsoft.com> wrote in message
news:0E0C4D43-8CEF-45F7-9DED- AB6287C67A87@microso
ft.com...
> Hello, I'm using FrontPage and MS Access on the Internet to do the
> following.
> I have a web page that displays the "Results" of a Database Querey.
> However
> the "Results" table will be displaying only few fields of the record. I
> like
> to have a Hyperlink field in every record that when it is clicked on will
> display a new web page with all the fields in that particular record. For
> example my "Results" table will be showing the Data of following fields:
> "Business Name", "Business Type" and "More Info" , like "The Dollar
> Place",
> "Thrift shop" and "More Info" I like to have a Hyper link to "More Info"
> field that when it is clicked on a new web page will open to show the
> detailed information about the "Thrift Shop" like "Address" and "Phone
> Number" etc... Can you help me please, thank you.
|
|
|
|
|