AnsweredAssumed Answered

Newbie creating a quoting form

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

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

Outcomes