Hi all,

I'm having difficulties relating 2 tables because the variable that makes them related contains duplicates on both sides. Allow me to explain.

Let's say we have 4 [Programs]

TABLE1: Each [Program] is rolled out at 4 [Locations] each having their own size [Modifier]
TABLE2: Each [Program] also has 4 [Phases] each of them having a number of required [Resources]

Now what I want is to see the [Resource] requirements per [Phase], FOR EACH [Location], realized by multiplying [Resource] with its [Modifier]

Would this be possible?

Thanks a lot!
Michael