Network map: relating three tables

[kleefaj]

Greetings.

I'm mapping the network for the school I work for.

Each room in the school has one to two jacks. Each jack connects to one socket on a patch panel (in a room). Each socket on the patch panel is patched into zero or one ports on a switch (also in a room).

I was thinking I would link a jack id to a socket id to a port id. This would let me see where a node plugged in and where on the switch it was connected.

But I don't know how to link these tables together. And I'm not sure how the interface would work: drill down to select the jack, drill down to select the socket, and drill down to select the port. Then join them. Multiple, scripted Finds?

ER diagram attached (not including link table).

I think I've been looking at this problem for too long and I can't see another way of looking at it.

Any thoughts?

Thanks,

Jeff