Drop down lists relating to other drop down lists
I have two fields next to each other. I want to be able to select from a drop down list on the first field, and force the second field to provide a drop down list that relates to the first field. I do have drop down lists for the first and second fields in another separate file, would it be better to have these in the file thatI am working on.
Also is this possible.