Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Subform not adding item

Post Reply
ozpritcha
Posts: 5
Joined: Thu Oct 16, 2014 3:06 am

Subform not adding item

Unread post by ozpritcha »

Hi all,

I've got an issue with building my mini app using NuBuilderPro.

I have a form with a sub form that is displaying records correctly.

The issue is that when I add a new record in the subform, it shows, but disappears as soon as I hit save.

The strange thing is that it was working before.

The SQL on the subform is simply: SELECT * FROM car_variations WHERE car_id = '#RECORD_ID#'

Any ideas?
admin
Site Admin
Posts: 2825
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 29 times

Re: Subform not adding item

Unread post by admin »

ozpritcha,

Generally a subform would link to a main Form via a foriegn key, not the Primary Key as you query seems to be doing. (#RECORD_ID# refers to the Form's Primary Key, not the subform's)

Are record actually being saved even though they are not displaying?


Steven
Post Reply