Dynamic columns [message #594342] |
Tue, 27 August 2013 10:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a379b07858f2c1d96a9f8577647eb826?s=64&d=mm&r=g) |
newbieinapps
Messages: 13 Registered: August 2013
|
Junior Member |
|
|
Hi all,
I have 2 tables T1, T2
T1 is having 2 columns t1_c1, t1_c2
T2 is having 3 columns t2_c1,t2_c2,t2_c3
I need to design a form which should be like
there must be a pop item (Dropdown menu) in a separate block.
If I select 1 from the pop item,
T1 with 2 columns should display in a tabular form.
If I select 2 from the pop item,
T2 with 3 columns should display and T1 with 2 columns should hide.
So the form should be dynamic based on the selected pop item.
Is there any chance to do this?
If so please explain me.
|
|
|
|
|
Re: Dynamic columns [message #594376 is a reply to message #594361] |
Wed, 28 August 2013 01:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You have two tables. Each of them should be represented by its own data block in a form. As you want to show only one of them, one option is to create two stacked canvases and place these blocks onto them - every block onto its own canvas.
A content canvas (which you must have) would contain a dropdown menu you mentioned. Depending on what you select, show one stacked canvas and hide another.
Or, you could try with tab canvases; that's maybe even simpler.
|
|
|