Ok so I have an SQL table with 2 columns, Part Number and Department.
So for instance, department 715 has 13 different parts it makes, with 13 different part numbers. and there are about 6 or 7 departments.
How can I configure 2 dropdowns so that when the department is selected from the first, the part numbers in the second dropdown changes to the parts that ONLY that department make?
...
Go to the complete details ...