Create record from form

F

Fysh

I have a form which allows user to input data to evaluate personnel.
However, there are times when the user needs to print out the evaluation form
to use rather than using the computer. Also, the user can print many copies
of this same report. If the user creates a record with students name then it
saves the record in the appropriate table. What I am attempting to do is if
the students name is blank then create the record in a separate table. The
reason behind this is when the user comes back to input the data rather then
typing all of the scenario criteria just use a pulldown to find the id of
that particular blank record. Also, since this same blank record can be used
for several poeple I don't want to save it in the same table as the rest.
Once the user selects the id I then want it to populate the form with the
initial criteria.

Sorry for that long reasoning, but here is my question. Is there a shorter
way of writing to save the record into another table rather than the original
table? For instance do I need to write rst![name]= me.name etc. Not every
field on the form is written to just one table, but I think I might need this
in one table when they select the id number.

Any thoughts would be helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top