Forums

Here is what I want to do but dont really have any idea how to accomplish it (still new to ChronoForms). I am using CFv5. I have a table (table1) with fields id1 and name1 (other fields but not important). I have a 2nd table (table2) with fields id2 and name2. I have a 3rd table with fields id3, id1, id2.

I want the user to be able select name1 from a dropdown (dynamic-I know how to do this).

Below that I am thinking I want a checkbox group that is dynamically populated with name2 (dont know how to do this). I can load the data but the checkbox group doesnt populate.

Then after checking the boxes, clicking submit should populate table3 with id1 for each id2 that is checked.

I am not even sure if this is possible. Any thoughts are appreciated.

Hi vividal,

If the second group was a Drop-down rather than a checkbox group then this would be what is called a 'double drop-down' see this FAQ.

You could perhaps use a multi-select drop-down for the second one; or do something similar with a checkbox group.

Bob