Getting data from previous record....
I am new to Filemaker and really like the potential of the program. I have used excel a lot for my work and I want to use Filemaker instead. However, I struggle with handling data because I still think in an Excel way...i believe...:) Now I have the problem of getting data from a previous record. In Excel it is easy, just make a reference to the previous cell. But how do I do this in Filemaker. What I want to do is this:
I have a record for every month in the year where there is a field which contains a start value (beginning of month) and a stop value (the end of the mont). The stop value of the previous month is the start value for the next month (the next record). How can I get the last field value in a record to be the start value in the next record? In other words lets say this is the january record:
Start Value: 2000
Stop Value: 2500
Then in the february record, I want this to be the default value when the record is created:
Start Value: "the stop value of the january record"