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
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
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
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