Pivoting from different tables

[esquivel88]

Hi all,

I apologize before hand, I did a quick search and could not find a solution to my problem. I want to create one pivot table from different tables.

Example:

Table 1 - contains brand information
Table 2 - contains sales discount information
Table 3 - also contains sales discount information

I want to create a table that pivot Brand from table 1, and adds the sales discount from Table 2 & 3.
Combining the tables is not an option as they are in different format, and moving columns around can be tedious. I played around with relationships but i cannot figure this out .

Any help please?



Thanks before hand..

Geo

 

[esquivel88]

All tables have the brands in common ..

 

[sudi_arta]

Can you give an example?? Since I can't figured out what do you want ??