Making tables from forms

[Carlos1815]

Hello. I'm new to this group and I have a question:
I created a form to build a quiz by entering the question,
distractors, correct answer and graphic name if one is used, and some
other information needed for the quiz. Once the user finishes making
the quiz, I would like to have the user press a button on my form so
that information in the form is put into a new table with the same
field names as the ones used in the form. I don't want the current db
that is linked to the form to be used as the final product; once the
new table is created and saved with a user-defined name, the form's db
is then cleared, or refreshed, so the form can be used to make another
quiz. I would greatly appreciate an help. Thanks in advance!

 

[Gina Whipp]

Carlos,

On builds forms FROM tables not the other way around. Now once the table is
built and linked to the form, there is no need to press a button, it will
automatically be entered into the table. Then you can set your form to be
Data Entry only which will always default to a new quiz.

As for saving a new table for each user, well please explain why having the
information in one table is a problem? I would think there is a place for
the person taking the quiz to enter their name. I am, of course, assuming
each quiz has a Primary Key?

HTH
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Carlos1815]

Carlos,

On builds forms FROM tables not the other way around.  Now once the table is
built and linked to the form, there is no need to press a button, it will
automatically be entered into the table.  Then you can set your form to be
Data Entry only which will always default to a new quiz.

As for saving a new table for each user, well please explain why having the
information in one table is a problem?  I would think there is a place for
the person taking the quiz to enter their name.  I am, of course, assuming
each quiz has a Primary Key?

HTH
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors





- Show quoted text -

I have to build a lesson in Authorware, and within the lesson are
small, 1 or 2 question quizes for every topic. I have the ODBC code
in Authorware call the necessary Access db. I would rather have
separate tables for each quiz made by the one form, but I suppose one
table for the entire lesson could be done. Thank you for your help!

Carlos
"Well, I have been training for a beer-drinking contest..." -- Beerfest