Hi jsantari,
It depends if you're doing on the frontend or in the CMSB.
I think what you're looking for are called "chained Selects". You can create all the related tables in CMSB but CMSB doesn't have a code generator for chained selects. You'll need to create them by hand with some custom code (php, mysql, ajax, jquery, etc). Here's some links to get you started: https://www.google.com/search?q=chained+selects
I've also seen components on the web where you output all the data into the source of the page (assuming you don't have thousands of records) and a premade javascript component builds chains selects from that. So that can be an easier method if you can find a component that does close to what you need.
That's all for the frontend, if you're doing it in CMSB there's some basic support. In the field editor create a list field and set the "List Options" to "Get Options from MySQL query", and then you'll see some additional options appear (Advanced Filter: Refresh list when this field changes). It easier, but still takes a bit of custom MySQL unfortunately, though.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com