Multiple dependent listboxes

[lazarosfs]

Hello,

This is my first post. I d like to congratulate everyone for this project.

I will explain my case and if anyone can help I D appreciate it.
I am trying to build a project for managing courses on a school.
Courses are divided to directions and classes
Teachers are divided also by directions
Courses get teachers based on directions

I use table for directions, for teachers, for courses and classes.
I have foreign keys of classes, teachers and directions to the courses table.

So to add a course I have to define direction, then a teacher of that direction.

Sometimes more nesting is required and I cant figure out how to do that for ex if I want to add course classes to teaching calendar.
Teaching Calendar table has all the above info and you basically choose a class by choosing direction, then course, then class
and the info shown must be direction,course,teacher,class.
My form has to filter all these in steps limiting the choices.

How can I handle this type of nesting?

[toms]

Hi,

What type of objects are you going to use? If you want a list based on anonther changing value on a Form use a lookup.
In the lookup's sql you can use Hash Cookies: https://wiki.nubuilder.cloud/ ... sh_Cookies

It's also possible to implement cascading dropdowns. Check out:
https://forums.nubuilder.cloud/viewtopic. ... ing#p14320
https://forums.nubuilder.cloud/viewtopic. ... end#p15408

[lazarosfs]

Thank you Tom I ll try both suggestions.
I really am trying to learn how to use it and am kind of lost.
The demo video of the invoice app really shows things by the second.

I think best for everyone to start would be to have a ready made demo nuBuilder forte working installation to see how things work.
I use lists so I ll try the lookups

[admin]

.