Sorting on a Flowfield

blackc2004

Hi all,

I have two tables, one of them has "detailed" transactions about the master table. From the master table, I created a flowfield which gets the current status from the detailed table.

However it always just get the first record for the filter. Is there a way to get the flowfield to get the last record? Can you use the key for sorting somehow?

Thanks.

jspopp

Hi, check your CalcFormula property on the Flow Field. You may have omitted something in your Table Filter. Good Luck!

davmac1

Does not seem like a flowfield function. max gives you the largest value.
To get the last status of a group of records, you probably need to add code which you can do in a form or page.
Post your CalcFormula and we can take a look at it.

blackc2004

Hi. I've attached a screen cap of the two tables with sample data and the calcformula.

Maybe I will have to just write a function to get the last status. But then is there any way to use the formula to populate the column whenever the record is read?

Savatage

Have you tried using max instead of lookup?

blackc2004

Savatage wrote:

Have you tried using max instead of lookup?

Thanks! That seems to have done it!

julkifli33

Hi what if we want to sort it based on other field?
cannot use Max.