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.