Edited: perhaps I should clarify a bit... I used the multi-page method thinking that if a person uses child form 1 to create a member... then child form 2 to create specific data for that member that will be saved in a different table (but linked to the member via the "id" created from submitting child form 1). I'm not using the currently logged user as the member. These are like family members being specified within the parent account which is the currently logged user. Hope this makes sense!
Posted: Array ( [m_type] => Child [m_fname] => dip [m_lname] => tester [m_email] => [email]djtester@gmail.com[/email] [m_phone_home] => 5091234567 [m_phone_work] => [m_phone_cell] => [button_9] => Next Step [9b2c4fbe5ca27b52d86efa4ea869184f] => 1 [1cf1] => f9e77169c61137fc98080afcb2bdc3ff [chronoformname] => member_group_form )
Files: Array ( )
Current step: 1
Fatal error: Call to a member function bind() on a non-object in D:\Hosting\#######\html\content\components\com_chronocontact\libraries\customcode.php(71) : eval()'d code on line 13
ChronoForms isn't finding the DB Connection for this form. Try refreshing it by setting the DB Conenction to No, saving the form, re-set to Yes and save again.
There should be no problem saving to different tables (though I'm not sure why you'd want to).
You can do it as I think you have by setting different DB Connections in each child form. Or you could do it once-off in the mother form by selecting several tables in the DB Connection tab and using distinct input names to save the values to the tables*.
Bob
* ChronoForms uses some Joomla code that matches the input fields with the column names in the table. If there is a match the value is saved. If you have 'text_1' in your form and there's a column named 'text_1' in 'jos_table_3' for example but not in 'jos_table_1' or 'jos_table_2' then that value will only be saved in 'jos_table_3'.
I tried to unconnect-save-reconnect-save the db... still wouldn't work. Then, when I peeked at the Table Manager... I noticed that the field I set for the primary key did not save as a key. I believe this is because I created the table from the form... then,it automatically used cf_id as the primary key. I wanted to use member_id instead. I added member id, set it as a primary key with auto-increment, then de-activated cf_id. Apparently this operation was not possible in one swoop - when I looked through phpMyAdmin... I noticed that the table removed cf_id and added member_id, but did not make it a primary key (probably couldn't while the other key existed?). I was able to switch the member_id to primary key and auto-increment in phpMyAdmin... then the form processing went as expected.
With regard to this comment:
* ChronoForms uses some Joomla code that matches the input fields with the column names in the table. If there is a match the value is saved. If you have 'text_1' in your form and there's a column named 'text_1' in 'jos_table_3' for example but not in 'jos_table_1' or 'jos_table_2' then that value will only be saved in 'jos_table_3'.
If the column named 'text_1' does exist in 'jos_table_1' and 'jos_table_2', will the value be added to both tables?
-coffeej