Need help with Set Field in script
I have a script that works up to the last step. In the last step, I want to put a value in a field using the Set Field command. In my script I start off in certain record on layout of Table A and end up in a new record on layout of Table B. Tables A and B are connected directly through a relationship using the Table A itemnumberID. In the last step of my script I want to show the Table A itemnumberID value from the record that I was working on in the layout of Table B. So I tried using the Set Field command but I cannot make it work. If I set my target as the destination field in Table B and then in the calculation I type in a fixed number that number shows up just as I want. But if I set the calculation as the itemnumberID field in Table A I get nothing. If I set the calculation as equal to the value of the field itemnumberID then I get the value from the first record in Table A rather than the value from the record I was working on.