Redirecting Field target in portal

[Ninjapowa]

Hello!

I have a portal which has an Item Cost field that points to another table. I would like to be able to overwrite this number by manually typing in a number if I want. I can already do this by having it point to a field that has an auto-enter calculation that points to the correct field. So when I create a new record, I see the correct Item Cost, and then I can go ahead and modify it without modifying the original Item Cost in my inventory. The problem is that I didn't set it up that way in the beginning, so if I do enable the Auto-enter field, the previous records have empty fields. How can I modify my records to add this capability or changing the Item Cost without affecting the original Item in the inventory?

thanks!

[Fitch]

Go to a layout based on the related portal records. Find all the records where your new field is empty. Do a replace based on a calculation that is the same as your auto enter calc. Does that make sense?

[Ninjapowa]

niiiiice, that worked perfectly!

thanks so much!!