Show last child record?

[xanx]

I am working on a solution in which "Client" is a parent record, and "Service Call" is a child of "Client". There may be one or more Service Calls related to one Client.

How do I get FM to show data from the last Service Call for a Client? It defaults to showing data from the first Service Call for that Client.

(Each Service Call has a date field called "Service Date", which indicates the date of that Service Call.)

Thanx, xanx

[Raybaudi]

Hi

sort discending the one row portal by "Service Date" .

[LaRetta]

Or sort the relationship descending, forget the portal and place the Service Date directly on your parent layout. If the need is only for this one instance, it wouldn't be worth the extra TO. However, if the existing TO will work as well sorted, I'd opt for relationship sort for two reasons, 1) one-row portal sort still sorts them all regardless of what is chosen to display and 2) portals flash more (particularly on Windows) than direct field placing. A portal with a lot of related records will jump and dance, hesitate and groan as it sorts - just to provide one row. Restricting the relationship is always worthwhile when sorting portals with a lot of related...

LaRetta :wink2: