Show latest record from join in main layout

[AA]

I am working on a database to keep track of the progress of repairs to
equipment. I am thinking I'd have a "History" file with just 3 fields:

Date
Status (from a drop down, such as IN PROGRESS, DELAYED, COMPLETE,
etc.)
Comment

I'd like to have that in a portal at the bottom of the screen to show
the complete "History" sorted in reverse chron order, but I want the
latest entry to be up above in a "Status" area which would also make
for easy reporting.

I know a summary field can find the latest date for me, but how do I
grab the other two fields from that record?

Thanks,

AA

[John Weinshel]

Instead of a summary field, use (what sounds like) the same relationship
displayed in the portal, but without the portal. Just show the three related
records. If the relationship is sorted descending by date, the fields from
the latest record will be displayed. I assume the relationship is generic--
showing all records.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance

"AA" <dka...@hotmail.com> wrote in message
news:efff8225.02031...@posting.google.com...

[Fenton Jones]

Hopefully you'll also have an EquipmentID in both files, and a
relationship between them, from Equipment to History, to base the
portal on.

Sort the relationship (a checkbox in the dialog) by the Date in the
History file, descending.

Then just duplicate the portal, and put it again up top in your
"status" area. Just show 1 row. That should be the latest date.

Alternatively, for the top field, you could create a field "LastDate,"
=
Last (portal relationship::Date)