Conditional Drop-Down Values
I have a table of products with the following fields and an example of the data:
catalog::type (asphalt shingle)
catalog::item (starter strip)
catalog::description (Pro-Start Starter Strip)
I have a second table (cash_estimate) that I use to generate a quotation. In this second table, I have a field populated with a drop-down list. I would like it to reference the catalog and only show values that match the category, type and item shown above.