Help...I am developing a simple single database. I have two to three fiels that I want to relate (maybe not?). Here it is... field1 is a drop down list of departments and field2 is a drop down list of equipment. What I would like to be able to do is to select a department from field1 and have field2 provide (auto) a list of equipment that are only available for the department I selected on field1.