Sorry for my english, I'm new to filemaker and I'm playing around trying to find a solution.
We are woodworkers. We produce taylor-made furniture.
We'd like our customers to get the price/quote for the pieces of furniture by entering measures and material.
We get it. A very simple database with one materials table and a calculation layout with some field:
- Measure (entered by customers)
- Materials (drop down menus related to the materials table)
- Final price (calculated)
But we'd like to add a specific feature. Sometimes furnitures are made of two materials.
We add a checkbox to tick when two materials are needed.
Then another drop-down list appears with second materials to chose, related to the same first materials table. CONFLICT.
How can I solve it?