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?
The end result is that the majority, if not all, of my charts/graphs need to have either a dimension of (Unit Number) or (Year), but not all tables have Year in the information.
I did make a link table for (Operating Period) and (Unit Number), but have no idea how to make another one without setting up a synthetic key.
