AnsweredAssumed Answered

Get value of last related field

Question asked by kjeller on Apr 15, 2016
Latest reply on Apr 21, 2016 by 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?

Outcomes