Let's say I've got 4 radiobuttons.
Each radiobuttons opens a subform/Table.
For Example:
button 1 button2 button3 button4
Each button belongs to each company. i am displaying total employees present in each company by selecting radio buttons
when I click on them they open subform/tablewhich should be dynamic ie (data is displaying from database)
if button 1 has 100 employees under it then by clicking button 1 it display 100 rows
if button 2 has 20 employees under it then by clicking button 1 it display 20rows
if button 3 has 30 employees under it then by clicking button 1 it display 30rows
if button 4 has 40 employees under it then by clicking button 1 it display 40rows
Please help me out..
If you do not know how to do any of it, you should read up on how to make a dynamic form with subforms that are hidden/visible, how to set up a database connection, javascript for making the buttons act as you want them. You can find lots of it here in the forum, also in the Adobe Developer Center. Also there are some good examples in the Forms Gallery that you can study.