Data Entry from Multiple Forms into single record

[LasersKR]

Hello All,

We are developing a Customer Service Survey that will have are users fill out a simple survey organized by topic across 6 forms (each form has a next and previous button to get to the next form). The problem we are coming across is that each form is creating its own record (meaning at the end of the 6th form we have 6 seperate records for one survey). I was wondering if it is possible to have all 6 forms enter data into a single record or , if not, if there were any ideas of a way to accomplish this without having 1 large form with all questions. Thanks in advance!

 

[KeithG]

Use an unbound form and then write code to add the record. Why can't you use a single form?

 

[KeithG]

You could also create Six seperate tables for each form.Join them with a One to One Relationship. This isn't proper database desighn though

 

[CEH]

I would simply make a seventh form and table. I am assuming that if you have six forms you are dealing with six tables. Each table being a topic with a primary key as that topics ID.... ie.... Topic1ID... Topic2ID.... Now if all of these topics are related to one survey... Should be easy... One table say... "TableSurveys" Have you fields like SurveyID (PK), SurveyDate, so on.. and all topics Primary Keys here as Foreign keys... This shouls allow you to relate all your topics to one survey.