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.
e.g.
/* 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