Forum Discussion

satlasg's avatar
satlasg
Helper I
8 years ago

Get most recent values on new table column

Hello,  I have two tables A & B with "many to one" relationship, as below:                I am looking for a formula to fill in 'Table B'[Value Latest] based on the Value from the more...
Need Help
nickchobotar's avatar
nickchobotar
Skilled Sharer
8 years ago

satlasg

 

Please make sure you have no ID duplicates in your Table B( Table 2)

 

Thanks, N -

satlasg's avatar
satlasg
Helper I
8 years ago

nickchobotar

There are no ID duplicates in Table B (Table 2), i double-checked through Count and Distinct Count, they have the same number as a result. So that is not the issue.

Keep looking around, thanks.

  • nickchobotar's avatar
    nickchobotar
    Skilled Sharer
    8 years ago

    satlasg

     

    Are you relating both tables on the ID field  or you have other keys ?

    Any chance, we can see the model diagram ?

     

     

     

    N -