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

mdPartnerNL
mdPartnerNL Member Posts: 802
edited 2013-10-24 in NAV/Navision Classic Client
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 :)

Comments

  • geordie
    geordie Member Posts: 655
    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:
    * Daniele Rebussi * | * Rebu NAV Diary *
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    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?

Categories