Nested lookups?

[Jawloms]

I would like to create a database which gives me ingredients based on a meal chosen, but want it to have multiple levels. For example;




You choose Carbonara. The recipe for Carbonara has in it things like "Chicken, Ham, Pasta, Cheese Sauce", but the "Cheese Sauce" is another recipe that it would then look in to so that the end result is the ingredients it tells you that you need are "Chicken, Ham, Pasta, Milk, Cheese, Flour".


Discussion of what actually makes a good carbonara aside, is this possible? I'm not even sure what to Google. Any good guides for that sort of thing around?


Thank you


Stuart

[Gicu]

Sounds like you need a tree view (hierarchical) structure, have a look at this:
https://www.access-programmers.co.uk.../#post-1672021
Cheers,