ChronoForms will allow you to save date for a form to more than one table using the DB Connection tab. You can also add code by hand to connect to a second database
Simple to use; connecting to a second database requires MySQL knowledge
This How-to document links to the recipes ‘Saving Form Data in the Database’ in Chapter 4 and ‘Getting information from a DB table to include in your form’ in Chapter 12 of the “ChronoForms 1.3 for Joomla! sites cookbook”.
Important: This document was written for ChronoForms v3 on Joomla! 1.5; it may be possible to adapt the contents to ChronoForms v4 and/or Joomla! 1.6 but this has not been tested.