Hi, hope everyone is doing well.
I have different child tables all feeding from one and only parent table. I want for the REF column of one of those child tables to:
1). Retrieve the difference between two lists.
2). That result should also contain only the latest values.
3). Be a dependent dropdown according to the place where the form is being filled.
I already made the first objective by substracting one list with another in a virtual column, but I cannot figure out how to make an expression that takes that list but only with the latest values.
Thanks in advance to anyone willing to help me on this one!