Different database join depending on dropdown value

[amittripathi2k2]

Hi,

I have three tables: Client, Personal and Company.

Now I have a requirement where I have a dropdown with three values: Client, Personal and Company.
What I need is that when I choose Personal from dropdown, I should be able to get the database join of Personal table, if I choose Client I get database join of Client and so on.

How Can I do this?? Any hint would be appreciated.
Thanks

 

[troester]

In element settings you can add actions in the "Javascript" tab to show/hide other elements depending on your dropdown element's value

 

[amittripathi2k2]

Yeah, it works that way but only for form. How would I get the proper result??
In form, for example if I choose Personal from dropdown than I am presented with dropdown from Personal Table.
But in list view I see all the three tables.?? How can I solve that?

 

[imagenweb]

can do with element CascadingDropDown

 

[troester]

Yes.
Combine your 3 tables Client... into one table A, e.g. with columns Name and Type, where Type is holding the value of your dropdown element.
Then use a CascadingDropDown element pointing to A and watching your dropdown.