|
| |
|
|
SirAldemar
Posts: 111
Joined: 3/4/2004
Status: offline
 |
Recursive DRW project - 7/28/2005 8:28:24
To all you guru's out there.
I have an access database with two (2) fields (actually has more but I only need to work with 2). Field 1 holds the equipment type and Field 2 holds the terminating equipment.
Example:
Record #: 1 2 3 4 5 6
Field1: Device1 Device1a Device1b Device1c Device1c1 Device1c2
Field2: Device0 Device1 Device 1 Device1 Device1c Device1c
What I need to do is generate a report (via a web page preferably) that when a piece of equipment is selected it will show all of the associated equipment. The harder part is that in this list we need to drill down and include all of the sub-devices and the sub-sub-devices, etc, etc.
Example:
Device 1 connects to Device 0
Device 1a connects to Device 1
Device 1b connects to Device 1
Device 1c connects to Device 1
Device 1c1 connects to Device 1c
Device 1c2 connects to Device 1c
Device 1d connects to Device 1
Device 1d1 connects to Device 1d
Device 1d1a connects to Device 1d1
Device 1d1a1 connects to Device 1d1a
Device 1d1b connects to Device 1d1
Device 1d2 connects to Device 1d
Device 1e Connects to Device 1
Etc.
Etc.
Etc.
In other words I need to search through the DB multiple times based on the previous searchs until I reach the end of the tree. I have gotten the first part to work (that was easy). But I can't figure out how to get DRW to do a new search with the data from the previous search.
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
