I have a database of over a 1000 customers. It has the usual address information, I now also need to add shipping information - Sea Port used for shipping
The City and country information unfortunately is text. Now to add the shipping information I created a table with all cities and ports with unique ID's.
How do I update my table of Customer Master with City ID and Port ID's efficiently? Manually means too much time and possibility of an error
The City and country information unfortunately is text. Now to add the shipping information I created a table with all cities and ports with unique ID's.
How do I update my table of Customer Master with City ID and Port ID's efficiently? Manually means too much time and possibility of an error