Calculating Pull Down List

[mrhooper]

I have a database where the records are assigned "types", say type-a and type-b. In another table I want to have a pull down menu which will only have either the type-a names or type-b names depending on which is selected.

Is there any way to do this easily?

thanks