dennisj
|
| Posted: 07/31/2003, 12:26 AM |
|
Hello again,
I want to display my data in a hierarchical way (like a folder menu), but it seems that the grid displayer doesn't allow a GROUP BY statement.
e.g. Busunit -> project -> emps is no problem, but
Busunit
project -> emps
|
|
|
 |
dennisj
|
| Posted: 07/31/2003, 12:39 AM |
|
oops
Busunit
-> project1
->emp1
->emp2
-> project2
->emp3
etc.
is not possible?
any suggestions?
|
|
|
|
RonB
|
| Posted: 07/31/2003, 1:13 AM |
|
The problem is that you know the words ending with a number shoud be grouped by the number. Your database will group them by the first letter etc. So unless you have another field that indicates the relationship between the fields I think your in trouble. You could add that field yourself offcourse.
Ron
|
|
|
|
dennisj
|
| Posted: 07/31/2003, 1:18 AM |
|
Ron,
Maybe I have to point my problem out more carefully:
I have a folders table with several levels and parent child relations (FolderId and ParentId) and a files table with a foreign key FolderId
So: BusUnit contains files and folders, and projects (child of busunit) only contains files
|
|
|
|
|
