Activate drop-down lists according to the data of the first list.

[Bibi44]

Good morning all,
I would like to create a drop-down list of a menu, with "starter, main course and dessert" and I would like that when I select "starter" it opens another list with all the entrees.
Is it possible.
Thank you for your answers.

 

[HyperOsmar]

@Bibi44 ...

Basically you will use two of the three types of elements: Dropdown, DatabaseJoin or Cascading DropDown.

I think the easiest is to use Dropdown with Cascading.

But whatever you use, you must create a table with your menu data.

Any questions, I'll be here ...

 

[Bibi44]

I watch
see you soon

 

[Bibi44]

Hello,
I cannot set up a drop-down list correctly. I did not understand the system.
Thank you for your help.

 

[troester]

For you admins:
Create a list e.g. "Type", elements id, type (=field); fill in your data: "starter"....
Create a list e.g. "Menu", elements id, type (=databasejoin to Type), menu (=field); fill in your data: type=starter, menu= entree1; type=starter, menu=entree2...

For your users:
Create a list e.g. "Order", elements id, type, menu,...
type=dbjoin to Type
menu = dbjoin to Menu, Ajax update=yes, Data-where something like WHERE {thistable}.type={order___type_raw}
(or menu =cascadingdropdown watching type)