I need help to create a database for telecom circuits. I’m not sure of how to approach it. Here’s a brief description of what I need to create. Each circuit has a point A and a point B. The ports for each site would be either originate (ORG) or answer (ANS). The equipment used at point A and B is the same. For example, Site A Node, Card, Port (ORG) -- Site B Node, Card, Port (ANS). What would be the most efficient way to create table(s) for this? I've tried making one table with columns such as SiteA_Node, SiteA_Card, SiteA_port, SiteB_Node, SiteB_card, SiteB port. I've simplified it here, but when I made this I had something like 20 columns for Site A and 20 columns for site B. But this creates a huge table with basically duplicate columns. And the queries don’t quite come out right. I've also tried creating a table like this: Site, Node, Card, Port, ORG/ANS; and just enter each end into its own row. But then I'm not sure how to combine the two rows to create an end-to-end circuit (which would be necessary for a report or display form), and make sure that I'm combining the correct data for Site A and Site B. Any help on this would be greatly appreciated. Thanks in advance.
2
