dix
|
| Posted: 03/20/2002, 11:07 AM |
|
i'm doing a search on a query that includes a main table and secondary table that contains a one to many relationship, main to secondary. (i.e. one organization to many service areas).
when i display the original page, if i use the query for the grid, i have mulitiple instances of the main organization, since it has many service ares (the service areas are not actually to be displayed until a specific record is requested.)
how do i keep the organizations from repeating in my inital grid? i have to use the query because they need to be able to search by service area, even though they are not displayed on the initial grid.
|
|
|
 |
Nicole
|
| Posted: 03/20/2002, 11:58 PM |
|
Dix,
try to use custom query with DISTINCT directive as source of Grid form. Add fields you want to search on to custom query and specify Input parameters for grid form as usual.
|
|
|
|
|
