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

    Get value of last related field

    kjeller

      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?