kshell

Jonathon, Can you tell me about your script to copy a field from the prior record and paste it into a different field in the present record? I'm having a problem that this may work for. See the thread: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=79681&fpart=&PHPSESSID= for a brief description of my problem. Thanks,' kshell

Wow, I thought that would be easy, but I was wrong! I'm a contractor and Filemaker novice, and every job has anywhere from 1 to 15 Change Orders and I need to keep track of the constantly changing completion dates and contract amounts. My database is called Change Orders, and I have a four fields in each record that need to work together: "Original Completion Date", "Current Completion Date", "Days Added To Project", and "Revised Completion Date". The value contained in "Original Completion Date" is from a related database, Jobs; that's no problem. "Days Added to Project" is a number, manually entered for each record, also not problem, and "Revised Completion Date" is a calculation of "Current Completion Date" plus "Days Added to Project", which works correctly and allows for weekend days. My problem is with getting "Current Completion Date" to contain the value from "Revised Completion Date" in the previous record. The link suggested before showed how I could access a text field from the previous record, but I don't see how to make it work with the result of a calculation. Likewise for contract amount: "Original...", "Current...", "Amount Added to Contract", and "Revised...", which I haven't yet tackled. Any help with my question will be greatly appreciated!

Hi Ray, Thanks for that link. That looks like it will work perfectly, and also shows me a technique for my next question, which was how to perform a similar operation to keep a running total of the contract value of the job. kshell

I have a DB for change orders and am trying to define fields so that the completion date of the project will always be automatically updated. In each record I have two date fields(CurrentCompletionDate) and (AdjustedCompletionDate) and a field in which I manually enter the number of days added to the contract for that particular change order. I have the correct calculation to auto-calculate the adjusted completion date from the current completion date, but my problem arises when I go to create a new record. I need the CurrentCompletionDate field on the new record to auto-enter the value from the AdjustedCompletionDate field from the previous record. I think it's an elementary solution, but I just don't see it. Any help?