AnsweredAssumed Answered

Getting Values from related filed based on the value in another related filed

Question asked by gartmorris on Aug 31, 2017
Latest reply on Aug 31, 2017 by philmodjunk

So here is what I have:


Two tables where the records are related by an ID number.

Table 1 each ID is unique and there is only one record per ID - There are fields A,B, and C

Table 2 there are multiple records with the same ID. - There are Fields X and Y

I need to get a value from Field X in table 2 based on the value of field Y in the same record and place that value (field Y) in Field A(or B or C) in Table 1.

I cannot use portals for my solution because of stuff I am doing further down the line.


I need it to be live as Table 2 will update daily ( I can use a script to do it if you cannot set field A,B, and C as a calculation).  All values will be numbers if that helps.


Thanks for any advice.