form fields for two tables

[Guest]

How can I get different form fields to pass data to two different tables.
I have a very large form with about 2000 cells and SQL only holds 1024.
I can retrieve data from the tables with queries, but the second half of the form will not submit data to the second table.
An error message says that the column cannot be found in the first table.
Any help will be appreciated.
Thanks.

[BKBK]

You might have attempted to insert or update form data into the first table, that was meant for the second table. Why don't you code the names of the form fields with indices, e.g. fieldname_1, fieldname_2, which immediately tells you which table the data will go to.

[Dan_Bracuk]

It's very easy as long as you are using cfquery and not cfinsert.

What percentage of your users do you expect to fill out all 2000 form fields?

[BKBK]

What percentage of your users do you expect to fill out all 2000 form fields?
100%, assuming, of course, Chief13 works for the IRS.