Page 1 of 1

Subform not adding item

Posted: Thu Oct 16, 2014 7:22 am
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?

Re: Subform not adding item

Posted: Mon Oct 20, 2014 7:58 am
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