We are attempting to populate a CFTREE using the results of a query. Our problem is that each level of the tree may not have the same number of items. We are ending up with NULL records showing in our tree. An example of the data structure would be:
DEPT
---MANAGER
-------EMPLOYEE
-------EMPLOYEE
---MANAGER
-------NULL
---MANAGER
-------EMPLOYEE
The question: How can we show the second manager (who has no employees) but not show the next level (null)? THX
DEPT
---MANAGER
-------EMPLOYEE
-------EMPLOYEE
---MANAGER
-------NULL
---MANAGER
-------EMPLOYEE
The question: How can we show the second manager (who has no employees) but not show the next level (null)? THX