I've attached a pic of my tables/relationships.
My database tracks cable runs in my video facility. The same SystemName is used as a lookup for both systemName_src & systemName_dst, and PortName is used as a lookup for both portName_src & portName_dst. Looking at my relationships to the SystemConnections table, I can update/cascade SystemName and PortName changes just fine to systemName_src & portName_src, but it leaves systemName_dst & portName_dst hanging unchanged... It's not a huge database ( less than 2000 cable entries ), but this could get me into trouble. I can't point the PriKey/lookup field to two items in the second table and maintain referential integrity and cascade updates.
I'd appreciate any ideas to solve this issue. ( I hope I did the attachment correctly ).