Flowfield last number

Hello I have one table with fields (ID,Description) and another table (Id,date,number) I would to add a field in first table to have the last number when I order by date Is it possible to do that with a flowfield? Can you help meThx

Hi, I think you need two flowfields: i) Date: with method Max to get the last date ii) Number: method LookUp to see the Number related to the last date. You have to put in TableFilter of this flow field the condition WHERE (Date=FIELD(Date)) Edited by - elbi on 2002 Jul 04 18:13:12

Yes, that run in Navision But I would to have the result with odbc too and with odbc, these method return always 0 :frowning: