Retain values in submission form created by database editor interf

B

Bob

I have created a submission form through the use of the database interface
wizard. I would like to find a way to preserve the values that the user
entered so that after the return to form is executed, the entries are
redisplayed. Many of the data records that are being entered only require
minor changes and most of the information remains the same. This would
greatly speed up the users data entry task.
 
T

Tom Miller

I have created a submission form through the use of the database interface
wizard. I would like to find a way to preserve the values that the user
entered so that after the return to form is executed, the entries are
redisplayed. Many of the data records that are being entered only require
minor changes and most of the information remains the same. This would
greatly speed up the users data entry task.

It occurs to me that if many of the values are not going to change why not
use an sql statement to change the fields in one shot instead of having a
data-entry operator change each record one at a time?.

If your inserting new records, that is different from "editing" the records.
When you edit a record you want the record that you have just displayed to
show you what is in that record. When your adding/inserting a record you
can setup "default" values that may apply to 90% of your new records. This
should be pretty easy to do using the data-validation of a form features of
FP. I know you can do it with raw html/javascript.

What it sounds like your wanting to do is have the new record form
"remember" what was entered on the previous new record and offer to create
an identical one. The D.E. operator would make the minor changes before it
creates that new record. Right?

It sounds like you need a standard new record webpage as well as "remember
last time" new record webpage.

This sounds like your going to have to take the Asp code that the FP db
wizard has created, clone it and tweak it. Since I am still re-newing my
acquaintence with Asp I can't offer any specifics.

Someone else..... :)


--
Tom Miller, Occasional PowerUser (Mcp, Mous, A+) and sometime Web Developer
Wannabe, More at: http://bccs.chatnfiles.com/ecard3.htm, International
Webmasters Assoc: www.iwanet.org, Owner: www.ChatNFiles.com bbs, Home of
770,000+ downloads.


... :
 

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