I have three tables (Order, City, Company) which contain the fields:
Order
OrderNo
ShipperName
ShipperCity
ShipperState
City
ID = numeric field
Name = actual name of the city
Company
Name = Order.ShipperName
Code = left(Order.ShipperName) + left(City.Name,3)
City = City.ID
I am trying to add new Shippers from the Order table into the Company table. However, some shippers already exist in the Company table.
Also, the Order.ShipperCity field can contain either an actual city, or a numeric value. I want to only select those records that contain a numeric value.
If I need to clarify more let me know and I'll do my best.
Order
OrderNo
ShipperName
ShipperCity
ShipperState
City
ID = numeric field
Name = actual name of the city
Company
Name = Order.ShipperName
Code = left(Order.ShipperName) + left(City.Name,3)
City = City.ID
I am trying to add new Shippers from the Order table into the Company table. However, some shippers already exist in the Company table.
Also, the Order.ShipperCity field can contain either an actual city, or a numeric value. I want to only select those records that contain a numeric value.
If I need to clarify more let me know and I'll do my best.