AnsweredAssumed Answered

Newbie creating a quoting form

Question asked by Lafyboy on Sep 12, 2011
Latest reply on Sep 12, 2011 by rjlevesque


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.