Double call - Same table

Discussion created by tausen on Mar 19, 2018
Latest reply on Mar 20, 2018 by tausen


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?

Thank you.