subform of a subform

[LuisAlmeida]

Hi,
first let me tell that i find nuBuilder a fantastic tool however i find very hard to acomplish one specific task:

Create and manage records in a Subform of a Subform of a Form. In Msacces that is very simple but i just can´t get it working in nubuilder.

the thing is:

I need to create somethig like the example of Invoices form but with one subform for the Invoice Item sub form and be able to manage both items and subitems

Is it possible?

Thanks in advance

[admin]

LuisAlmeida,

nuBuilder can't do subforms inside a subform.

You can however launch an Edit Form from a subform.

Therefore having table1 in a Form and table2 in a Subform with a button that opens table2 in a Form with table3 in a subform.

Steven

[martbarr]

Yes am just about to do this sort of thinkg myself.

I have students with many academic programmes, each prog having many modules, each module having many assignments, and each assign having many "assignment events".
So am going to have a student form, with programmes as browse-in-subform, launching an edit window on programmes.
Then the programmes edit form having a browse-in-subform for modules, launching an edit window on modules.
Then the modules edit form having a browse-in-subform for assignments, launching an edit window on assignments.
Then the assignments edit form having a browse-in-subform for assignmentEvents, launching an edit window on assignmentsEvents.

This is brilliant - our academic staff are so excited at having this level of easy "cascading" access to student records which we cannot do with Filemaker. Well we prob could but the scripting languag is about as bad as it gets for a real programmer. (fantastic for the desktop user though) and nuB is so fast and simple conceptually. And does what it says on the lid !

A litle more complexity - each programme and module is pulled from a list of `standard` progs and modules - so each of them needs a lookup for the many-many - but all quite do'able.
I'm hoping to have the working solution end of this week.
What other builder tool is there that can match that !

My only issue will be the sql to pull back various reports for staff, but will crack it - using open source flyspeed to visually build them.

Keep up the good work guys.
Martin

[LuisAlmeida]

Thanks for your reply,

Now that you told me that it can be done is it possible to point me to an example or tutorial?

[admin]

Luis,

Put openForm() on a button.

Below is where you can find the Form ID..

Capture.PNG

Capture1.PNG

Code: Select all

nuControlKey=true;  //-- this makes it open in a new window
openForm('145e240f5c0588',nuGetRowId());

Hope this helps


Steven

[LuisAlmeida]

thank´s!!
It worked like a charm

[admin]

cool