Help I have created a big database that stores IP information for Pc's, Printers, Switches, UPS
EquipID (Always 2)
EquipID (Always 1)
Example a reservation contains the IP and the device ID, switch name and port number.
I have reservations for switches as well as these can be daisy chained together.
The boss has asked me to create a report it a switch is knocked out, that be is simple but, the tricky part is to get the report or query to display the data the first switch in the daisy chain is knocked out.
Printer 1 and 2 connected
switch 2 connected
Printer 3 and 4 connected
switch 3 connected
Printer 3 connected
So far the query can tell me which devices are connected, but if I selected switch 1 I would it to tell me that everything is effected
Can any one help with this, I think its going to involve a lot of subforms
Probably not what you want to hear but you may have to make a change in your table structure. Somewhere you need to establish a Parent/Child relationship between your connected devices such that the first device in the chain doesn't have a value in the parent field but all of the subsequent devices do. Once you've established this you can work backwards from the device you are interested in ( or forward if you are starting with a parent device ) to get a listing of all the devices that are 'related' to the one you are questioning. I have used this a lot with employee tables where you have to track who reports to who, along with their titles and department information, all the way up to the top of the organization.