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

    Newbie creating a quoting form

    Lafyboy

      Title

      Newbie creating a quoting form

      Post

      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.

       

      Screen_shot_2011-09-12_at_4.09.05_PM.png