Newbie creating a quoting form
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.