AnsweredAssumed Answered

The best way to create a record

Question asked by dave_1 on Oct 3, 2011
Latest reply on Oct 25, 2011 by dave_1


The best way to create a record


I am working on a system that provides the user with a screen of information to fill in, and then I record it in the database (yes, thats what we all do I hear you saying!)

My question relates to the best way to create that record.

By default FMP records each value as you move from field to field, so hypothetically if you had 20 items that needed to be filled and the user stopped at 11 items, FMP would have stored all the values for you.

I would prefer to have all the data stored at the record level at once rather than the field level as you pass from field to field via a 'Im finished record my data' style button.

What is the best way to have FMP do this?

In the example above, if the user leaves the screen with only 11 of 20 items filled, Id love to pop a message box that says moving away from the screen will lose the information, but I am not sure on exactly how to go about this.

Any help would be greatly apprecated.  Thanks!