Hi,
I am evaluating the community edition and what I want to do is the following :
I created a form that writes data in a header table using an id (a counter).
In this form, I want to use a subform with a grid that will write to a detail table, based on the id of the main form. That means that the relationship will be one-to-many, one record of the header table will match with several records from the detail table, using the id to join the tables.
All the examples include the form grid of the enterprise version, but I need a solution at the community version. I tried some code that found in the knowledge base (store data using bean shell) but obviously I do something wrong, as only one record is written at the detail table (with the id) and the other fields are null.
Can someone give directions of how can I do it ? If it is possible of course...
Thanks in advance,
Petros.