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.