Further to my question on calculating time elapsed the other day, it seems my problem relates to the fact that I want to retrieve data from a previously submitted form. All the information I can find on this relates to dynamic linking of 2 separate files/forms in a project, where a field in one is updated to reflect the answer previously given in the other. My problem is that I want to backwards-search incidents of the same submitted file/form until I find the one where a certain field (date) was changed - and this is the field I want to now appear pre-filled in my new form. Back to my trap situation, I set a trap lure (week 0), and fill out a date field for when the lure was placed. I return every week to collect insects, using the same form to collect other data. Each week, I want the date that I entered entered in week 0 to show up as the date that the lure was last changed. If in week 4 I change the lure, and record that date, then each of the following weeks, I want week 4’s date to show up as the date that the lure was last changed. And so on, each time I change the lure.
Is this possible?
If so, then I think I can do the calculation to work out how many weeks have elapsed since the use was changed…which is what I was asking in my previous post on elapsed time.