Sorting a repeating field by date?

[ambweb]

Keeping a contact file in filemaker pro. At the bottom of the layout I have 2 fields, the first contains the last date I spoke to that individual and the second are notes from the conversation. Currently these are repeating fields with 20 repetitions each. Ideally I'd like the most recent conversation to always show up on top of this list. Is there a way to do this with the current setup?

If not is there a way to do it? What about a way that whatever Itype in those fields gets added as the top line of a "log" field?

[Vaughan]

Sorry, cannot do easily with repeating fields. (You'd have to create a script that does the sort by cutting and pasting the field values around between repetitions, and it would not automatically run itself.)

Had you used a related file for the dates and conversations records, you could set a portal up to automatically sort itself any way you wanted AND it wouldn't be limited to 20 entries.

Re-do the solution as related file.