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.1 person found this helpful
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
In case of using collections, do we have to change the current form structure i.e. current block is based on database table (there is no desperate logic to insert).
Can you guide me how to proceed by using collection?