I have three tables
manufacturers (id, manuf_name)
cigar_lines(line_id,line_name, id) id is foreign key from manufacturer table
details(detail_id,details,line_id) line_id is foreign key from cigar_lines table
The first combobox needs to get values from the manufacturers table. I want the user to select a manufacturer, have the second combobox populate with all the cigar lines made from that manufacturer(line_name), and then the third combobox populate with all the cigars within the chosen line(details). Any help would be greatly appreciated.