two fact tables en two attribute-tables

[curiousfellow]

I have two attribute tables and two fact-tables

Both attribute-tables should be joined with the fact tables

Because the fact-tables don't use allways use the same atrributes I created seperate joins.

So attribute_table 1 has a joint to fact1 and to fact2 and attribute_table2 has a join to fact1 and to fact2

when running the load script I get a message  that there is a loop.

The only solution I can think of , is to create seperate attribute tables for facts1 and seperate attribute tables for facts2.

In that case I have to make separate listboxes too, something i want to avoid.

Is there another way to solve this ?

I enclose a qvw to explain the problem i am facing.

[marcus_sommer]

The easiest way would be to concatenate both fact-tables and very probably I would it do this way.

- Marcus

[Mark_Little]

Hi,

Taking a quick look and like Marcus says, concatenate the two.

Mark