Frontpage Dbase Database Query

[Glenn Johnson]

I have Frontpage 2000 and using DBF files.

Problem: I have created an ASP Webpage that lists a few fieldss on a
DBF table file. I would like to be able to click on the ADDRESS field
and have it take me to another page(ASP) that displays the rest of the
record.

When I try to do this, it displays the current selected record and not
the choosen record from the hyperlink.

I can resolve this using Access and creating a Key field, but I don't
have that luxury. The data on the DBF file is changed too often to
convert to Access, so I need to avoid that step.

File Name: freemetr.dbf
Key Field: address (not really a key field, but needs it to be)

What is the best/easiest way to resolve my problem and still be able
to use DBF files?

Could a SQL Query help? Don't know how to write the Query.

Any ideas that would help? THANKS....

 

[Jon Spivey]

Hi,
Presumably you already know using address as a primary key isn't a good
idea. You should really have something like a customer id as an
autonumber/identity field for each record. If I were in your shoes I'd
change the database now - might seem like a lot of work but it's going to
save you no end of hassle down the line.

If you can't/don't want to you'd use a custom query like this
SELECT *
FROM Customers
WHERE Address = '::AddressField::'

and your links woould look something like
<a href="show.asp?addressfield=whatever">show details</a>