[SUBFORM] Can Not Be Display On The MAIN FORM

[rhadisubrata]

Hi im new user of nubuilder. I dont know if i can post it in here.

I already follow the tutorial especially for the Form and Subform (Invoice Item) of PIZERIA tutorial before i used the updated version there are no problem to display the GRID of SUBFORM. Now i can not display it on my FORM (Invoice).

This is my screen shot :

problem using subform and form.jpg

This is before i use the update version :

this is the screencapture before the updated version of 10 Oct 2022.jpg

So what do i have to do to solve this ?
Thanks

[kev1n]

Hi,

Please verify that the form and Foreign Key are (still) entered:

Click on the Options Menu, then select "Subform Object"

options_menu.png

And then select the tab "Subform"

subform.png

[rhadisubrata]

Hi,

Please verify that the form and Foreign Key are (still) entered:

Click on the Options Menu, then select "Subform Object"
options_menu.png



And then select the tab "Subform"
subform.png

Hi thanks for the reply , i already cofigure the subform but the issue is stil the same.

Already did it but no changes on the form .jpg

I did the exact step on each version , the version before updated => it works perfectly but when i use the new updated version => it can't works

Please help. Thanks

[kev1n]

Do you see any errors in nuDebug Results?

[rhadisubrata]

Do you see any errors in nuDebug Results?

The RESULTS is something like this :

[0] : ===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list'

===SQL===========

SELECT `` FROM zzzzsys_setup WHERE (`item_inv_id` = '-1') AND (0)

===BACK TRACE====

/home3/rhadisubrata/abc.com/core/nuform.php - line 1001 (nuRunQuery)

/home3/rhadisubrata/abc.com/core/nuform.php - line 400 (nuGetSubformRecords)

/home3/rhadisubrata/abc.com/core/nuapi.php - line 91 (nuGetFormObject)

[kev1n]

What does the subform's SQL look like?

[rhadisubrata]

What does the subform's SQL look like?

TQ so much for the reply.

The sql either for form and subform is something like this
This Is For The Subform

invoice_subform.jpg

And this if for the Form (Main)

invoice_form.jpg

[kev1n]

Thanks, this is showing the db schema and not the form's SQL. This can be found when you click the subform's options menu (see above), select "Form Properties" and then the SQL can be found in the "Browse" tab.

[kev1n]

Hi,

Is this solved?