subform usage

[olivier]

Hi there, happy new year.
I try to add a subform in a form, without success to far.
The best explanation I found is http://forums.nubuilder.cloud/viewtopic.p ... how#p12755 but it's for nubuiliderV2.0 and interfaces changed.

I tried subform wizard as well as doing it 'by hand', i.e. adding a subform type field in my form, and playing with SQL request. The best I obtained is the tab and title for the subform, but nothing more.
I even tried to put 'select * from <subform_table>' in the SQL of the subform, but nothing appears.
I added some objects into the "Objects table" (I'm confused that I do not have access at existing objects to be selected), that created dedicated object, but not totaly filled (i.e. I add "pai_montant" in the Objects table, that creates a corresponding object without type, table name, order, etc. )

Any help ?
I have mainly to tables :
- Table1 with field table1_id
- Table2 with fields table2_table1_id, table2_value

I would like to see all records from table2 where table2_table1_id=table2_value when looking at table1 records

Thanks a lot for any help or step by step

[olivier]

I found at least one point that must be looked at and that can help other: be sure not to put 0 in height of subform, otherwise it is in the tab, but not visible... It's the height, stupid !

[admin]

olivier,

Try creating a table (for a subform) with just 3 fields, a Primary Key, a Foreign Key (to link to the Main Edit Form Primary Key) and a simple text field.

Then create a Subform Object and then a Text Object and link it to that Subform.

Capture4.PNG

And see if you can get that to work.

Steven