I have a drop down menu that I’m trying to dynamically populate. The data is actually stored in two data types – Menu and Menu_Taxonomy). In the “Menu” data type I have the values (“Name”) that I want to display in the menu, but I need to only show a specific type of menu, so I need to first look in the Menu_Taxonomy to get unique IDs that relate to the right taxonomyand then search in the Menu data type with the Unique ID.
The “Menu” data type’s unique ID is stored in the related record on the “Menu_taxonomy”.
How can I create a drop down that essentially joins the two data types together to get the data needed?