I'm trying to figure out a way to connect 2 groups of 4 tables with two different fields names without getting a synthetic key. 1 group of 4 is connected by the group name Operating Period. The other is connected by the field name Unit Number. One table links the two groups right now by having both fields names in it. This all works fine.
The issue I am running into is that a couple of tables on both groups that have a field called year in them as well. I need to link them by Year as well as, but not have a synthetic key. Is that something obtainable?