Question - Generating a new table based on conditions from an existing Database

Help Studio
, ,
1

Hey all,

So the idea is I have an existing database of menu.
Say if I have 300 menus in the database, and within of each menu there’s raw materials and the quantities needed, etc.

I want to be able to automate this and generate a table based on set condition - with one click away.
For example, if I need to generate a menu list for a whole week (7 days), where each day I want to have a list of:

  • 4 main course menu based on parameter of base protein material (beef, chicken, duck, etc)
  • 2 side dishes based on a different set of simple base protein or carbohydrate (potatoes, spinaches)

How would I go about creating this Random Menu Generator based on a preset condition? The parameter themselves and IF conditions I have an idea how to approach them, but as to which activities that allows me to generate this one click away, I’m not too sure.

2

@Dillon_Marius

How is the actual table structure does it say about which item has what items?

If yes then first create someyhing like filters at each level with the selections on different columns and based on selection pass the values to be filtered

Cheers