ASP database page, field hyperlink to 2nd page

[M Fountain]

I have 2 ASP pages with joined databases created by an
SQL link. The SQL is fine. When I run the database wizard
and put in the SQL code, I see all the fields I want from
both databases.
However, when on the second page I try to do what the
help file says and go to the More Options in step 3 of
the wizard, the Criteria button is grayed out. Can this
mean that there is something in the Front Page Extensions
or the ODBC configuration on the server that needs
changing?

Any help welcome!

 

[Jon Spivey]

Hi,
If you're joining tables you must be using a custom query - in which case
it's up to you to set whatever criteria you want in the query. Once you go
the custom query route FP can't hold your hand any more. You'd type
something like this as your query
SELECT
A.Field1, A.Field2, B.Field1
FROM TableA A INNER JOIN TableB B ON A.Id = B.Id
WHERE A.Id =::FormField::

Note the criteria is set in the WHERE clause.

 

[Guest]

I've done that, but the help file says that to format the
second page, you still have to use the wizard and in step
3 click on options and enter the the criteria through the
More Options->Critera button in the wizard. It seems to
offer no way to complete this process manually.

MF

 

[Guest]

Actually it turned out to be infinitely simpler than I
thought - I didn't need to do the joins at all - just
pass the linking field to the second page. Your hint that
I could code this myself pointed me in the right
direction. Thanks!