gabs
|
| Posted: 11/21/2002, 11:56 PM |
|
Could anyone help me on how to create an ASP page
where ONE Search TextBox can search Multiple Tables and
display it's results on Multiple Grids?
Example
TABLE - External Failure
TABLE - Internal Failure
Common Field between the two - PRODUCT NUMBER
So have a Grid with External Failure, and a Grid with Internal Failure
That when you search for a PRODUCT NUMBER you will get the result of each table on it's corresponding grid on the same page.
SEARCH BOX
---INTERNAL FAILURE GRID
result
----
---EXTERNAL FAILURE GRID
result
----
Thanks in advanced
Gabs
|
|
|
|
xbill
|
| Posted: 11/22/2002, 8:59 AM |
|
Here is the outline for CCS- the CC approach is
similiar, but a little harder to work with.
The search works by adding a new POST (or URL) variable
and passing it to the grid on the same page or a new page.
The grid on the destination page matches the variable and
filters the results. To get to the filter variables - use
the middle "data" tab on the Properties toolbox- select
the datasource and click the three dots on the right hand
side. This brings up the SQL editor- you can then click
on one of the rules to see the exact match.
To do two grids- use the grid+record builder to create the
first grid. Review the generated grid- there will be
a search parameter in the SQL editor.
Create a new grid with the grid builder- and add the
same search parameter to the second grid.
You can also change tables or add additional filters- as long
as the name of the field from the search parameter
is the same.
-bill
|
|
|
|
gabs
|
| Posted: 11/22/2002, 9:53 AM |
|
Thank you very much "xbill"
Worked like a charm !!! Many thanks again !!
|
|
|
|
|
|
