bigtoe
Posts: 115
|
| Posted: 01/06/2005, 9:59 PM |
|
I have a database table called "A_items" with the columns:
Customer_ID, Customer_Name, A_Quantity, A_Availability, ...
I used CCS to create a Search and Grid form page.
The Search contains Customer_ID and Customer_Name.
The "A_items" Grid contains Customer_ID, Customer_Name, A_Quantity, A_Availability, ...
All this works fine.
I also have a table called "B_items" with the columns:
Customer_ID, Customer_Name, B_Quantity, B_Availability, ...
I would like to modify the above form page so that:
a. It contains 1 Search and 2 Grids.
b. The "A_items" Grid contains Customer_ID, Customer_Name, A_Quantity, A_Availability, ...
c. The "B_items" Grid contains Customer_ID, Customer_Name, B_Quantity, B_Availability, ...
d. The Search contains Customer_ID and Customer_Name.
e. The Search button would produce results for BOTH of these 2 Grids.
How do I modify the above form page to accomplish this?
Thanks.
|
 |
 |
Proton
|
| Posted: 01/09/2005, 1:32 AM |
|
It's very simple. The search grid working on form. When you click "search" button, the form send your choise (i.e. Customer_ID = 1) as the adres param. In both forms you can get this param and insert into SQL syntax. Look at the first grid (if he was generated in wizard) and do the same in second.
(I'm sorry for my english, but hope you underestand me)
|
|
|
|
bigtoe
Posts: 115
|
| Posted: 01/09/2005, 4:38 AM |
|
Ok.
Where is the grid's SQL syntax located?
And how can I give this SQL syntax the search parameters?
Thanks.
|
|
|
|
|
