Forums

Hello,

I have a list form and a details form as per the db multi loader tutorial. However in forms manager the table connected is shown as blank even though in the db save settings I have the correct table selected (jos__chronoforms_data_supplier) and if I enter data it is saved to this table.

I added a new field to the detail form and I assume I now have to update the table. Therefore in forms manager select the detail form, create table and instead of the connected table I get #__chronoforms_data_Supplier_detail. In the field list the new field is present. If I stick with #__chronoforms_data_Supplier_detail and save a new table is created with the correct fields. If I edit tablename ie jos__chronoforms_data_supplier the new field is not added to the existing table.

When I returned to the forms manager both the list form and the detail form do not have a connected table.

latest build of V4 on J 1.5.25.
Regards
Paul
[attachment=0]table_name.jpg[/attachment]
[attachment=1]db_save.jpg[/attachment]
[attachment=2]connected_table.jpg[/attachment]

Hi Paul,

The table drop-downs always show just a dash, a coding choice of Max's (though personally I'd prefer that a table showed up).

If you add a new input to your form then you will need a new column in your table. If there is no useful data saved then you can drop the old one* and start again; more often you'll need to use PHPMyAdmin or something similar to add the column to an existing table and preserve the data. This version of ChronoForms doesn't have a table editor.

Once you have the new column, you need to re-save the form to refresh the internal records.

Bob

*You'd need PHPMyAdmin anyhow to drop the old table so you may as well edit it.

Thanks Bob,

I guess that's why the button is called "create table" and not edit!
regards
Paul