Can I create one form witch when submitted writes to two different tables in a TEST DB that have a Parent/Child field of "ID"?
For example:
Section 1 of the form has "Name", "Address", and "PhoneNumber" plus hidden filed of "ID". All its fields write to a table in the TEST database called "Information"
Section 2 of the form has "RequestAction" and "DateRequired" plus hidden "ID" field. All its fields write to a table in TEST database called"Details".
"ID" in "Information" table has parent/child relationship with "ID" in "Details" table
Can this be done? The DB is MSSql 2000.
Thanks