What #sql #database structure would most naturally lead to a cascading dropdown?
The answer is a composite (multi-key) relationship with a supporting simpler relationship involving a subset (N-1) of those fields.
A composite (multi-key) relationship is any single relationship that involves multiple fields joining two tables.
/* Composite Relationship */ ALTER TABLE Invoice ADD CONSTRAINT FK_Invoice_to_ProductModel FOREIGN KEY(ProductID, ModelID) REFERENCES ProductModel (ProductID, ModelID); /* Supporting Simple Relationship */ ALTER TABLE ProductModel ADD CONSTRAINT FK_ProductModel_to_Product FOREIGN KEY(ProductID) REFERENCES Product (ProductID);
dbFront automatically creates cascading dropdowns whenever it sees a composite relationship chained to a simpler relationship.
For the full details and implementation see: dbfront.com/cascadinglookups