Fetch Records Troubleshooting
I'm at a loss right now. I have Table 1 that lists fields ID, Length, Amount. I am trying to Fetch records into Table 2 when the ID entered into table to is equal to the ID in Table 1 and insert Length and Amount. Here is my code but it doesn't return anything
x =Table1[ID == input.ID2];
input.Length2= x.Length;
input.Amount2 = x.Amount;