I'm working on a database where I've got values that need to be carried forward from week to week. IOW, on a current "note", I'll input some data, like weight, and the next week's note, I'll need that previous week's weight in the field for "previous week".

Do I need to create a table for "previous weights" or is there some way to just display the previous week's weight without having to do that?

Similarly, there are some checkboxes that are marked on each week's notes and I'd like those checkboxes marked with the previous week's values.

Seem like you need a lookup from the previous record.

See if this helps.

http://fmforums.com/forum/showtopic.php?tid/201291

That's helpful but I'm not quite sure how to implement it.

Can you have a look at my database? It's messy but the tables I'm referring to are called "weights" and "weights 2".

New_CH.fp7.zip

I see what I did wrong in defining my relationship - I had the wrong key referenced in my logic. Now that I've fixed that it works. Now the issue is that if the weight is changed in the older entry, like if there was typo, the newer weight's record is not updated. I even have the auto-enter calc to replace existing value.

Well a lookup will not update that way. It needs an action for it to perform a relookup.