You need to set Table
Set Variable [ $CurrentDestination ; Value:"\"" & "HISTORY::P_" & $CurrentField & "\"" ]
Why have you placed a "\" around your destination? In your initial post it looks more like | but either way, I would remove. You do not need to escape out any quotes or have the | char.
I'm not sure what you are saying. I do have the variable $CurrentDestination set.
Let's say my current active field is PRICING::Total_Estimate.
$CurrentDestination then contains "HISTORY::P_Total_Estimate" (with the quotes).
Is there a specific Set Table command that I am missing somewhere? I haven't seen one.
@jgomes384 - That is the way to concatenate quotation marks into a calculation.
It makes $CurrentDestination = "HISTORY::P_Total_Estimate"
otherwise $CurrentDestination = HISTORY::P_Total_Estimate
Without the quotes I didn't even get a result. I was getting ?. Now at least I'm getting an error so it's seeing something.
You do not need the quotes, it was working before just not as expected (with a ?). Now, it is looking for table "HISTORY:: to exist.
What kind of information are you copying? Is your field large enough to display on your layout - this could cause a ? to appear if you are copying numbers.
Thanks! I found the issue. You're right, it works the way you said.
The History table will contain multiple revisions. I didn't take that into account. It was copying the data into the first found record instead of the one I was looking at. So I broke it in my attempt to fix it.