Auto-Enter Text from previous record from DIFFERENT field

[tmanning]

I have a database where an applicant must list all of their previous residences. I would like to automatically enter the move_out date from a previous record as the move_in date of a new record. Because this will be a hidden field and does not affect their actual move in date, it is okay if the field is a calculation since the data does not have to be modified. I would like to do this without using a script. Any suggestions?

[The Bridge]

quote:

---

Originally posted by tmanning:

I would like to automatically enter the move_out date from a previous record as the move_in date of a new record.... I would like to do this without using a script.

---

Off the top of my head, i.e. there may be a better solution out there, one approach would be to create a self-join relationship using the customer's unique id. Make sure that the relationship is sorted so that the last record created for a customer will be the first to appear in a portal. You can do this by sorting (descending) by record creation date, for example.

Then define the Move In Date field to Lookup the value in the Move Out Date based on the above relationship.