join tables with many to many relationship using vba

[paul100]

Hi. This is my challenge. Join 3 tables (or more as defined in macro) each having 3 fields with a many to many relationship with the last column the product of the percentages in the row. Ie. In the first row of the result table the calc is 10%*100%*5%=0.005%. at the moment im using powerBi to build the table but would like a vba script.

Table 1

P000061, water, 10%

P000061, stormwater, 90%


Table 2

P000061, growth, 100%


Table 3

P000061, civil, 5%

P000061, land, 95%


Resulting table

IN.P0000061, Water, 10, Growth, 100, Civil, 5, 0.005

IN.P0000061, Water, 10, Growth, 100, Land, 95, 0.095

IN.P0000061, Stormwater, 90, Growth, 100, Civil, 5, 0.045

IN.P0000061, Stormwater, 90, Growth, 100, Land, 95, 0.855



Thanks

Paul