Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Subform not updating/inserting

Post Reply
mlgeek
Posts: 23
Joined: Tue May 08, 2012 8:24 pm

Subform not updating/inserting

Unread post 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
You do not have the required permissions to view the files attached to this post.
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform not updating/inserting

Unread post 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
mlgeek
Posts: 23
Joined: Tue May 08, 2012 8:24 pm

Re: Subform not updating/inserting

Unread post 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
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform not updating/inserting

Unread post 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
mlgeek
Posts: 23
Joined: Tue May 08, 2012 8:24 pm

Re: Subform not updating/inserting

Unread post 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!
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform not updating/inserting

Unread post by admin »

"Its OK to feel ashamed" ..(futurama)
Post Reply