Flowfield to show last record in a table, 1 field or 2

mdPartnerNL

I want to see the description of the last record (kind of a log file) in a table.

With a Flowfield, Max on "Entry no", I see the last Entry No of the last record. But how to see the Description of that last record.

It must be easy

geordie

Silly clue: using a second FlowField which show description, based on the one you've created, using a calculation formula's table filter like "Entry No.=FIELD(YourFlowfield)".
Never used a FlowField based on another FlowField, I honestly don't know if works :oops:

mdPartnerNL

My thought exactly so that's what I started with.

It looked like it worked, but I depends on the form or page it is used on. It needs a calcfields(); in onafterrecord.

So +1 for first suggestion but can it be done in 1 field?