You want to look at Dependant Data Validation.