I have a filed value that need to be replaced with a value from the same field based on another value in the table. Let's call the field "cost" in the table 'Location". The unique field is "item". In this case , an item exists in multiple locations, field name 'loc'. In each location, a unique item may have a different cost in each location. I need to replace the cost value in tertiary locations from the cost value in the primary location. I have no problem writing a script to replace all values in any given field, but I'm having trouble crafting a script for this process.
June 12, 2009 5:06 PM
June 15, 2009 3:32 PM