Look Up From Last Related Record

[marcobraynio]

Hi

I am trying to autofill part of a record using Lookups, but I don't know how to get it to find the most recent related record.

In more detail I have a call record, which includes a patients medical history within it. If that patient calls again I want to create a new record which I've done and pull through the most recent medical history so I don't need to re-enter. I can get it to pull through the relevant data using lookups, but not the most recent - please help.

Thanks

Mark

[Fitch]

One possibility is to create another relationship to the history table that is sorted by date descending, and base the lookup on that.

But why do you want to make multiple copies of the history data in the first place?