1 reply to this topic

[jparram]

Using mom demo 5.0

I am trying to figure out how to determine who an item is being shipped to. In the Item.dbf there is a Ship_to field that seems to point to a customer stored in cust.dbf...but there are also null values and 0's in this field. What is a sure fire way to link an Item to it's shipping address?

Thanks

[dseibold]

We don't use multiple shipping addresses so we use the following method:

Look up the order number in the order field in the CMS.dbf table. Then look at the Shipnum field and see if there is something other than null or zero. Otherwise use the number in the Custnum field.

Then look up the Shipnum or Custnum field in the cust.dbf table to get the name, address, etc.