Forums

This topic is locked

Search problem?

Posted 17 Nov 2002 03:12:01
1
has voted
17 Nov 2002 03:12:01 keith Lo posted:
I created a search page with two variable field - account number & company name. There is a result page with 2 recordsets (X and Y - two independent Access table). By inputing the account no & company name, the client can view the relevant info of the two recordsets. There is also another detail page which have more info of Y recordset.

My project is the user only need to input the account number and company name once, they can view the result page (info of X Recordset) and the detail page (info of Y recordset).

I tried to test it but the result is even the user input the variables, Dreamweaver Mx did not filter the variable under the Y recordset, it only displayed all records.

Under the Data Binding>Recordset(query) of Y recordset, I input the same filter variables & Run time value (like what I did in X recordset)

Request.Form("AccountNO"

Did I miss something or wrong step?

Reply to this topic