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...Thanks! We'll email you
when relevant content is
added and updated.