Filemaker/Filemaker Pro


QUESTION: I have a database of my products with prices, serial no, name, etc.
I have about 700 products. The manufacturer raises the product prices every year by a certain percentage.I create a new calculation field every year and add say 0.05 to my existing prices to get the new price.

My problem is that I end up with too many price columns that I don't need. I would like to erase or get rid of the previous year's price column. I don't know how to do that without loosing my current price.

Thank you.


You only need two fields.  PRICE is the actual price field that you will use to keep the prices in and PRICECALC is the temporary field you will use to update the prices.   Replace the data in the PRICECALC field with a calculation that gets the new prices correct.   Do you understand?   Whatever you have to do to get the correct prices, put it in the PRICECALC field (so that you don't take a chance on messing up the current prices in the PRICE field)

Then, when the prices are correct in PRICECALC, simply replace the data in the PRICE field with PRICECALC.  Does this make sense?   Email me at and I will help you further.


---------- FOLLOW-UP ----------

QUESTION: Thank you for your reply.

Yes this is what I do every year but how do I replace the data in PRICE with PRICECALC? Also how do I avoid all the past sale and invoice amounts from changing?

Once you have determined that the data in the PRICECALC field is correct and thats what you want in your PRICE field, just click into the PRICE field in any record and choose Records > Replace Field Contents > Replace with Calculated Results > and specify the calculation to be PRICECALC.  This will replace the contents of the PRICE field with the contents of PRICECALC.

Now, if you do this, your invoice amounts WILL change.   It sounds like you need to change your database around so that the old invoices will remain the same.   Email me directly, and I will help you.



All Answers

Answers by Expert:

Ask Experts


Jamey Key


NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.


Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.

©2017 All rights reserved.