My two tables are FoodGroups and FoodNames. The FoodGroup table has two columns Food_Group_ID and Group_Name. The FoodNames table has Food_Group_ID and Food_Name. My filter variable is Food_Group_ID. What I'm missing appears to be how to submit the variable to the second recordset.
The last question is once the second list is populated, will I use the same method/code to select what's displayed on the page.
Thanks for any help.