Hi,

I have a table named "Customer" whose field is "Address"
I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is a roll up field.

In my case, i only want to retrieve the last address of the last linked customer. So if i have ["Customer1","Customer2"] in "Target Customer", the "Latest Address" must be Customer2's address only.

How can i achieve this?

Note: Customer1 and Customer2 are not related to any created time or updated time or any min max value. The sequence is totally random. Thank you