Qrew LegendI am just on my phone now, so I can't see your relationship diagram very well, but if, in fact, you say you have a recursive relationship where each Weight in knows the value of the previous weigh in and it seems to me that if you are very conscientious and planful about your field naming you could then do a look up of the previous weeks way in and that would end up being the second previous weeks weigh in and then you just keep going like that and you can hop your way back.
If this was a traditional grandparent parent child type relationship with multiple tables, you would just do the look up down and down and down. So it's the same thing except with a recursive relationship.
The alternative, of course us to get fancier with a Formula Query, but that's probably not necessary.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
