Combine Key

[sorcha999]

I have a table that contains location information. There are currently two different locations that I would like to combine into one record (a location on the border that used to be broken up into Texas and Mexico they would like to be designated now as just Mexico)

This table is being used elsewhere as composite key. Example/Product_ID Location_ID

What is the best way to make this change.

Thanks.

 

[MatthewPeters]

Not sure exactly what your after here. If you could provide your table structure (with sample data) and your expected outcome then I'm sure someone here can help you.