I have two drop down list pulled from mysql using php
vendor
fault
vendor aaa & bbb share the same fault categories - downtime - tat - hardware
whereas ccc can only have
My problem is, how to design a relationship in mysql db, so that data can be pulled like chain select?