Sep 23, 2008 01:24 PM|sjnaughton|LINK
Hi Grayaid, have a look at my blog and in particular
A Second Advanced FieldTemplate which has a cascade ForeignKey FieldTemplate that allows you to filter based on a second FK, you may be able to modify it to suit your needs.
Or try this
This is a FieldTemplate I created to do something silmilar(Note the DB is in SQL 2008)
Hope this helps [:D]