I am developing a Filemaker product database for kitchen units. I have 50 different products each product has a variety of options including wood type, finishing and size options. Each of these options have an percentage effect on the product price. The problem is that each product has a varied combination of these options. These variables are the same across the products but not all products have all of the variables.

What is the best way to structure my database so I can have a product list which on a product by product basis I can assign the variations to.

I am fairly new to filemaker so apologies for my ignorance.

As no one else has offered any help yet ... a simple starter would be one table for products and another for options joined by a third table. See attached

products.zip