I am trying to generate wire run lists and have a new report for each reference designator. Each table is to show to refdes, for each wire i.e. from and to. The issue I am having is that if the refdes shows up in the "to" column on one table/report it will not be included in its own tables "from" list.
I require the following format where for every connector from it is to show all the wires connected to that connector and where they are going to (once all the tables are generated each connector/pin from should be listed twice).
connector (from)|Pin(from)|Wire Number|Wire Gauge|Connector (To)|Pin(To)
I look forward to any feedback, Thanks.