Is it possible to have the fields in a form post to two tables.
I have a set of checkboxes come from another table. I sort of want to mimic an "other - please specify" type approach where I have the select boxes and then have say 5 text fields. If the one or more of the 5 text fields is filled in the values of those should update the main table for the form they are on but also update the table where the checkbox values are coming from.
Not sure if I'm explaining that ok.
Many thanks!
Greg