AnsweredAssumed Answered

Select record with highest value in certain field and transfer value of other fields to other table

Question asked by boismaison on Oct 30, 2009
Latest reply on Oct 30, 2009 by philmodjunk

Title

Select record with highest value in certain field and transfer value of other fields to other table

Post

In my FM10-database I need to select the record with the highest value in a certain field (say field "MaxValue") and next I want to put the value of other field (say "productname" in the selected record in a field of another table. I know I can use the function "MAX" to select the highest value, however I am not able to figure out how to transfer values of other fields to other tables.

Outcomes