AnsweredAssumed Answered

Use Value from another record in a calculation?

Question asked by morgkl6 on Feb 29, 2012
Latest reply on Feb 29, 2012 by LyndsayHowarth

Is it possible to use a value from a different record in a calculation?




For example, let's say I own a retail store, and I have a database that- on each record- has 1) customer contact information 2) the date 3) how much money the customer spent at the store on that day. I want to create a field that automatically calculates how much money a customer has spent the current day PLUS the last time they were in the store. Is this possible?



Thanks for the help.


p.s. I am using Filemaker Pro 11 Advanced.