I am working on an estimating database and need to know if there is a way that I can merge records or do something similar to that.
What the user will be doing is quoting a price for a fiberglass tank. The tank sizes vary, and sometimes there are more than one tank on an order. The way the database needs to work is the user will enter a quote number in and fill out the required fields. At the end there is a total price for that size tank times the number needed.
Currently I have that working. The problem comes in when I try to add more than one different size tank on to the order. When I go to add another record with the same quote number it pulls up the orignal and starts changing the information on both of the records. Also, I need the printable estimate to show the subtotal for each tank and then the grand total for the whole order, but cannot figure out how to two records if they have different quote numbers.
I am fairly new to FileMaker, so I used the template for estimates they had and have just been modifying what I need.