This content has been marked as final. Show 4 replies
I believe if I was doing this, I would take your current setup and make that block a non-database block and just use it to gather my data for the "real" database block that I would not have displayed on the canvas. I would then add logic, either in the WHEN-CHECKBOX-CHANGED trigger or in a "Process" button if you had one that would contain the logic to loop through your non-database block and insert the appropriate number of records into the database block for each of the channels that was chosen.
I would go the other way round. Create a database view which selects the data in the way you need it to display in your form.
To handle the updates, create an INSTEAD-OF-trigger on the view which then does the necessary inserts into your tables.
Base your block in forms on that view.
You may have to change the Keymode to Non-updateable and maybe create your own ON-LOCK-trigger.
This keeps your form simple and hides all the logic in the database.
Hope this will fix your issue :
Why don't u take something called a collection and collect all the relevant data once the apply/submit button is pressed and save that data in the table.
Rather a simplified one than changing ur form structure. But the problem is selecting the exact kind of Collection