Associate 2 non linked Fields

[Anonymous]

Hi all,

I am in learning phase of QV. Please help me in solving the below issue.

I have 2 List boxes coming from 2 different table and those 2 table have no association with each other. Since, I cannot give the details from project, here is the sample data :

A:

LOAD * INLINE [

    State

    MH

    RJ

    MP

];

B:

LOAD * INLINE [

    City

    Pune

    Mumbai

    Jaipur

    Udaipur

    Bhopal

    Indore

    Satara

];

A:

LOAD * INLINE [

    State

    MH

    RJ

    MP

];

B:

LOAD * INLINE [

    City

    Pune

    Mumbai

    Jaipur

    Udaipur

    Bhopal

    Indore

    Satara

];

These 2 List Boxes on UI has no link between each other. How do I associate them together so that when I click

1. State: 'MH', City:'Pune,Mumbai' get selected

2. State: 'RJ', City: 'Jaipur, Udaipur'

3. State 'MP': City: 'Bhopal, Indore'

Please help.

[YoussefBelloum]

I'm ok if it is an external table.

But for this example (a geographic dimension table), I would go for joining all the fields in one table.

[bramkn]

We don't know about the data really. He did say this is sample data.

[jonathandienst]

Coding the relationships in an expression is simple if you have two or three to consider. But what if you have several thousand? And how would you manage changes to the relationship that is encoded in a very long expression. Finally, any changes or additions require changes to the model, whereas the data driven approach does not.