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.
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.