Jose APC
|
| Posted: 03/08/2002, 5:03 AM |
|
Good morning,
I was wondering if anyone knows how to create a nested grid. I'm kind of a newbey to cc, and any help would be nice.
I'm working on create a phone book with multiple departments. The output would look something like this
department 1------------phone0
user1-------------------phone1
user2-------------------phone2
user3-------------------phone3
department2-------------phone0
user1-------------------phone1
user2-------------------phone2
and so on
calling these types of records by themselves doesn't seem to be a problem, but showing them all at the same time has been impossible so far. Short of breaking every department into it's own table, I don't know what to do.
Has anyone ever worked with anything like this before?
Thanks for the held
Jose A.
|
|
|
 |
glenn@pivotal-z.com
|
| Posted: 03/08/2002, 12:16 PM |
|
It may not be elegant but it should be simple:
Can you add a sort feild to your table? Use it in the form's Order By clause. You could add records with blank descriptions to create 'spaces' on the grid.
|
|
|
|
Nicole
|
| Posted: 03/11/2002, 5:28 AM |
|
Jose,
try to join two queries results on one form. Create Grid form for users and order them by department_id. Then you should insert additional record for department. Create Custom Show event where build and execute sql statement for departments. Look at the article Report-like Grid: http://www.gotocode.com/art.asp?art_id=103&
and use the similar approach to insert department record
|
|
|
|
AJ Henley
|
| Posted: 08/26/2002, 10:16 AM |
|
These solutions, while helpful, seem kludgey. I have both CC and CCS, and it seems you can't nest a grid in either without a huge workaround. Or am I missing something?
|
|
|
|
AJ Henley
|
| Posted: 08/28/2002, 11:44 AM |
|
hmmm...still no response.
HEY!!! Yes Software guys!!!
Is there a way to nest grids in CC or CCS?
|
|
|
|
Superkikim
|
| Posted: 08/29/2002, 4:48 PM |
|
The forum is a users community. I you have support questions for Yes Software, go to the support site http://support.codecharge.com. They are always helpfull and pleasants
|
|
|
|
