Get newest value from a related field

[Dagel]

I'm completely flummoxed. I have a customers table and an orders table. I would like a field in the customers table which will show only the most recent order quantity from the field orders::qty.

 

Ideally, I would like to do this without a script.

 

Thank you!

[LaRetta]

Hi,

 

If your orders relationship is not sorted and if the last (most recent) quantity is the last record in Orders then you can create a calculation (result is number) in Customers with:

 

Last ( Orders::Qty )

[comment]

Or - if this is for display only - you could use a one-row portal showing only the most recent order. You can use portal sorting or portal filtering to achieve this.

[Dagel]

LaRetta- That was actually what I first attempted. I guess because it's a shadow table of an SQL database, it doesn't quite work the same.

 

Comment- Unfortunately, it's not just for display purposes.

 

Unless someone has a better idea, I think I'll need to create a mirror table of the SQL database and use the Last function.

 

Thanks to you both!