Multiple Forms saved as one record

  • Thread starter Thread starter Dia Shadrick
  • Start date Start date
D

Dia Shadrick

Can you create multiple forms but have them save as one
record in a table? Form 1 contains questions 1-40, form
2, contains questions 41-80. I want all of the data to
be saved as one line item within the associated table.

Thanks,
Dia
 
Can you create multiple forms but have them save as one
record in a table? Form 1 contains questions 1-40, form
2, contains questions 41-80. I want all of the data to
be saved as one line item within the associated table.

ummm...

No. You really DON'T.

If you have a one to many relationship between questionnaires and
questions, a better design is to store one answer *per record*, not
create 80 fields for your answers! See Duane Hookum's excellent At
Your Survey sample database at

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

If you really want to use this non-normalized structure, you might
want to consider using a single Form with two tab pages - 40 questions
on each page.

If you *really* want two Forms you can base as many forms as you like
on a single table. It will be awkward for the user since they will
need to close the first form before opening the second, lest they get
an error that they're trying to edit a record which is already open by
another user.
 
Back
Top