Finding last portal record

[sboard0599]

I have a DB in which I have a portal showing records in another DB. It basically tracks operations and the times they were performed. The portal shows all of the operations from a certain job. I am building a schedule that will show the last operation from that job. How do I find the last portal record based on time and date of operation. Right now it always finds the first operation.

[Vaughan]

There are a couple of ways... one way is to sort the portal by time and date descending so the "last" record appears first!

Do you want to display the last related record in a portal, or do you wnt to *go to* the last record?

To display the last record, make sure the relationship sorts by date and time appropriately. Create an unstored calc field (called, say, "LastPortalRow") that counts the number of related records. Then use the script step:

Go to Portal Row [by field, "LastPortalRow"]

This makes the protal scroll to display the last record.

To *go* to the last record, use the Go to Related Record [show] script step, then change to the relate file and use the Go to Record/Request [last] step.