1 Reply Latest reply on May 16, 2013 7:01 AM by philmodjunk

    Calculation misunderstanding

    justjoker

      Title

      Calculation misunderstanding

      Post

           Hello,

           I've got a table:

            

           ID_Price

           Date Modification

           Price

           Max_Date Modification

           Max_Price

            

           The task is to get a calculation field that brings up the price, that was modified last.

           It's a related table.

           Know it's simple, but ...

           What is the way to get the result at the related table? At a perent one? Can't get it. Thinking I'm stupid...

           Please, help

        • 1. Re: Calculation misunderstanding
          philmodjunk

               If the relationship is:

               Products::ID = Prices::ID_Price

               You either sort your relationship by Date Modification in descending order and then any reference to fields in Prices from Products will refer to the most recently added record for that ID value

               OR

               You can keep the relationship unsorted and use the Last () funciton to refer to a field from the most recently added Price record for this ID.