Many connections to reference table

[BenziD]

Hi all

I have orders table four elements from the same type, each element represent different test/campaign,  One order can relate to several campaigns at the same time.

I want to create relationship the test table and three shortcuts of the test table to the order table
How can I do it?
thank you

[Alp]

I am not sure I understand your case completely, but let me guess and here what you can do.

Create Alias Shortcuts in the import layer for your 3 test tables, then create model query subjects for test table and 3 alias shortcuts in the model layer. Change query item names as required and then get the query subjects from the model layer to the presentation layer through sortcuts.

- Alp

[BenziD]

Hi
thank you for your answer.
I did that but when i connect the slias shortcut popup window asks me if i want to "create shortcut to the existing relationship"
yes - open window that I can't change anything
no - open the option to set up relationship - but the results are the results of the first relationship

and that my prob.

http://picasaweb.google.com/lh/sredir?uname=100275298313660254814&target=ALBUM&id=5531908411883920353&authkey=Gv1sRgCKj_1djA1Z7B4gE&invite=CJ-I_LYN&feat=email

(hope that the link works...)

B

[Alp]

You say: " but the results are the results of the first relationship". Why would they be different?

Did you mean adding filtering conditions in the model for each aliased query subject?

- Alp