jparram's Content

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

jparram's Content

There have been 3 items by jparram (Search limited from 28-April 23)

By content type

See this member's

Sort by

Order

#2067 Ship_to: Customer Address for Items

Posted by jparram on 16 April 2008 - 06:30 AM in MOM & FOX Database Issues

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

#2066 Hello

Posted by jparram on 16 April 2008 - 06:24 AM in MOM FAQ Introductions

I'm shooting from memory here since I don't have the time to look right now. But I believe you'll need to include BOX, CMS, CUST, INVOICE, ITEMS, JOURNAL and STOCK. You'll also need PRICE if wanting to list the pricing.

Great!...Thank you for your help

#2061 Hello

Posted by jparram on 11 April 2008 - 08:39 AM in MOM FAQ Introductions

I am new to the forum and to MOM.

I am currently working with MOM ver. 5.0 demo. and I am building an interface to query Order information and inventory information. What tables would I need to query to produce the information generated when you do an order lookup?

Thanks