anonymous
Fri Jul 16 12:54:51 CDT 2004
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!
>-----Original Message-----
>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
>>-----Original Message-----
>>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.
>>
>>--
>>Cheers,
>>Jon
>>Microsoft MVP - FP
>>
>>"M Fountain" <anonymous@discussions.microsoft.com>
wrote
>in message
>>news:2e6b001c46b4c$4f42c940$a501280a@phx.gbl...
>>> 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!
>>
>>
>>.
>>
>.
>