1 Reply Latest reply on Sep 13, 2011 7:44 AM by rjlevesque

    Newbie creating a quoting form



      Newbie creating a quoting form


      Hi everyone!

      I'm trying to build a quotation form in Filemaker.

      I work for a company selling large machinery with various options.

      Each option has a price and different specification.

      Anyway I built a small test database but when I select a option from the drop down menu on the quotation form it changes the original value in the Options list table.


      Is there any way to prevent that?

      I just want to reference values from the tables, so I can build a machine not change the options list values.

      Am I doing something wrong with the relationship?


      Currently I have 3 tables

      1. quotation form - Main entry form

      2. Machine Model Pricing - Model & pricing

      3. Option list -options listed with pricing.