Complicated Matrix

[ester_pr]

Hi,

I have to create a table that takes dimensions and measures from diffrent tables, for example:

Payment - sum filed wher filed rechiv 0001 from payment table

Expense - pay filed wher filed tipe 0005 from expenses table and so on

The fileds are not in the key table because ther are too many , the key table has the time and the place

I know i  need matrix tables for the hedlines

dut how do i :

1.show the hedlines even when ther is no rechiv in thet time or place

2. put all the matrics hedlines in one chart table?

I hope i was clear

thank's

Ester

[pover]

Your key or link table would need to contain all the possible combinations of the keys to work properly.  I prefer to concatenate all my transactions into 1 table.  It simplifies my development, runs faster and sometimes uses less RAM.  Keep it simple and don't use the link table.

Karl

[ester_pr]

Thank's but I thought of a different wey because actualy i have lotes of tables in the model