I have a table that has a department name drop down box, once a user chooses the department the next field is item. I only want items in the previously chosen department to show up in the drop down box. I have a table that has all items, with a department name, and a table with department names. The department name drop down was easy, but how do I list only itmes from the item table that are in the already chosen department table.