I have a simple layout that calculates for example Total price by multiplying unit price*quantity. There is a related database that uses the unit price to calculate some other things. My question is that for example in countries with high inflation where prices change almost every month, every time I change a price it recalculates the older prices with the latest one!!.

How could I have the oldest prices untouched and recalculate only according to the latest price.

Thank you

Pablomac

Hi:

Sounds like you need a join file. There are several examples and instructions on this. You can search these forums or look in the FM help. There are also a few examples. FileMaker has a solution called the Solution Framework which is an invoicing system. There are a lot of them out there. You could also check fmfiles.com

Have fun

Ken

This is the perfect place for a 'lookup.' This sets a value once and leaves it that way unless you explicitly re-lookup the value. Take a look at the user documentation for an overview.

Dan