Forum Discussion

arhomberg's avatar
arhomberg
Icon for Helper I rankHelper I
5 years ago
Solved

Create a New Column That References Previous Record in Another Table

Hello Everyone!   I am looking to find a way to create a new column in a table that looks for a record in another table with the associated id, and pulls a column from it.       Above is ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi arhomberg 

     

    You can use UI to Group Table1 by id, find the max systemmodstamp, then join Table2. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi arhomberg 

 

You can use UI to Group Table1 by id, find the max systemmodstamp, then join Table2.