Records Overwritten in a Simple Form

Records Overwritten in a Simple Form

Postby prosmart » Sat Apr 02, 2016 4:57 pm

Greetings

I just started to play around with nuBuilderPro.

Created a simple table consisting of DescriptionID (int 11 and auto increment) and Description (varchar 64)

Went into the form wizard and created a form for this table.

First thing I noticed was that only the Description field was available for selection. Although in this case this was what I wanted, I'd like to know why the DescriptionID wasn't available and how I could make it so

Second problem was when I ran the form and created a new record.

I entered the new description text and pressed "Save".

Got a message saying that the record had been created., however the description stayed on the form. When I entered a second description, it overwrote the first one.

I then discovered that if I use a "New" button before I enter the second Description (ie after the "Save"), then everything works as I would have expected.

I tested this again creating what I thought was four records one after another, only to discover that the result was only one record.

Obviously if you are entering multiple records, you don't want to have to go in and out of a form.

Question: When I press "Save", how can I get the form to automagically refresh ready for a second record?

Thanks and Regards

Nigel.
prosmart
 
Posts: 1
Joined: Sat Apr 02, 2016 4:39 pm

Re: Records Overwritten in a Simple Form

Postby admin » Mon Apr 11, 2016 3:33 pm

Nigel,

This is the way we suggest you go about defining tables structures in nuBuilder...

http://wiki.nubuilder.net/nubuilderv3/index.php/Recommended_Table_Structure

Fast Forms will create its own Primary Key and it will be a unique string rather than an autoID..

Steven
admin
Site Admin
 
Posts: 3234
Joined: Mon Jun 15, 2009 9:53 am


Return to General