Create Table : missing field set with dynamic data

Hi

My form contains some checkbox group fields with the dynamic data option set at yes.

When I launch the Create Table menu on my form, the fields, set with Dynamic Data=Yes, are missing in the result. When I disable the dynamic data option on one field, this field is available in the result of the Create Table.

Could you please help me to fix this issue ?

Thanks in advance

Hi

Thanks for this workaround. I have succeeded to create the checkbox group filed in the table.

Now I have an issue to save the content of the checkbox group field in the table. I use Handle arrays following by DB save in the event 'On Submit. In the SQL Insert command, the value related to the checkbox group field is set to 'Array'. Therefore the SQL insert fails with the error '1054 - Unknown column 'Array' in 'field list' SQL=INSERT INTO ...'

Maybe I miss something in the setting of Handle arrays or Db save, but I don't know what

In attachment my form

Thanls in advance for your help

Regards

Hi stephbart,

Please remove the [] from the list of input names in the Handle Arrays action

listJoueursS,listJoueursV

Bob

Hi
It's fixed.
thanks