Making tables from forms

  • Thread starter Thread starter Carlos1815
  • Start date Start date
C

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!
 
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
 
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 -
Click to expand...

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
 
Back
Top