Page 1 of 1

Subform not updating/inserting

Posted: Wed May 09, 2012 7:51 pm
by mlgeek
First, thanks! Been playing with NuBuilder for a few weeks now and have really, really been impressed.

Second, I have what is likely a very stupid question that I'm a bit embarrassed to ask- but I have watched all the tutorials and I have been through the entire wiki and forum, so I'm hopeful that Steven (and any/all contributors) will forgive me:

My form (ISSUES) has a subform (FOLLOWUPS).

Image

All other things are working well, but when I enter new items into the subform (FOLLOWUPS) and click "Save," they disappear and do not appear to populate in the database...nor do I receive an error message.

What (probably very stupid thing) might I be doing wrong?

Apologies in advance,

-mlgeek

Re: Subform not updating/inserting

Posted: Thu May 10, 2012 7:14 am
by admin
mlgeek,

My first guess is..

The "Field Name" for your objects ("Follow-Up Date" and "Follow-Up Detail") probably don't exactly match any field names in your Followup Table.

Steven

Re: Subform not updating/inserting

Posted: Thu May 10, 2012 4:32 pm
by mlgeek
Thanks so much for the reply!

That's not it, though. The headers you're seeing there are for the subform field's Title, not the Field Name.

For the purpose of eliminating this as a possibility, though, I've now changed the Field Title to match the Field Name- same problem.

Here are the subform objects:
Image

Here are the fields of the database:
Image

Other thoughts?

Again, thank you for taking the time. If I can get this project working properly, I have lots of other plans for ways to use NuBuilder.

Best,

-mlg

Re: Subform not updating/inserting

Posted: Thu May 10, 2012 11:52 pm
by admin
mlgeek,

How do numbers get in the primary and foriegn key fields FU_id and issue_id when you have made them varchar(15)?

Have these been imported into your nuBuilder app?

FU_id and issue_id shouldn't be put in the subform, nuBuilder will update these fields automatically.

This could be the reason you can't add anything new.

If you still have problems, post a "print screen" of the Subform Tab on the Object Form, so we can have a look at it.


Steven

Re: Subform not updating/inserting

Posted: Mon May 14, 2012 3:12 pm
by mlgeek
Okay- feeling dumb. I was incrementing via a method for older versions of NuBuilder, before it supported auto incrementing. Many thanks, and my apologies for the stupid question- now working great!

Re: Subform not updating/inserting

Posted: Tue May 15, 2012 4:18 am
by admin
"Its OK to feel ashamed" ..(futurama)