5 Replies Latest reply on Apr 21, 2016 3:03 AM by kjeller

    Get value of last related field


      I set up these two related tables:


      Table 1: Customer

      Field A: Primary key

      Field B: Name

      Field C: Last event


      Table 2: Event

      Field A: Foreign key

      Field B: Date

      Field C: Event


      How can I get the value from 2C into 1C from the record in 2 where 2B have the last date?