I am very new to SharePoint and am having trouble with a few basics I thought were simple, it's a large change from my way of thinking about databases and presentation.
Anyways, I am required to populate one drop down with choices from a list and then, based off what the user chooses, populate a second drop down that should filter data based off the first drop down. I normally understand these produce's using using SQL tables with Keys but I am a bit confused how to go about this here.
I am using SharePoint foundation 2010