copy data from portal

[IEW]

I want to go to the last row in a portal and copy a field to the layout where the portal resides. I have a quote file that stores quotes by date. I want to display the latest quote on the master inventory layout where the quote portal resides. This will give at a glance the latest quoted price for this part no., even thou it is in the portal. The portal is sorted by date, therefore the latest quote will always be in the last row of the portal.

[-Queue-]

Have you tried duplicating your relationship and sorting by date descending? Then your 'first' related record, i.e. the one you would see with a simple related field (not a portal) on a layout, should be the most recent.

[barracudaxxx]

Go To Portal Row [select, Last]

Go To Field [select/perform, "Relationship::FieldName in Portal"]

Copy [select]

Paste [select, "Your Target FieldName"]

Does this help?

[-Queue-]

You may want to switch the Go to Portal Row and Go to Field statements, if you have more than one portal on the layout. Also, you can use Set Field [ fieldinthisfile, relationship::field ] instead of the Copy/Paste steps.

Still, I think it would be easier to use a descendingly sorted relationship and avoid scripting altogether.