RE: Ship To Limit


(system) #1
Gary,

I use the ShipTo, ShipHead, ShipDtl, OrderHed, and OrderDtl tables in my
query but I also check the order's line price when I process my query (so
you probably won't need the OrderHed or OrderDtl tables). The ShipTo table
uses the Compnay, CustNum, and ShipToNum from the ShipHead to identify the
correct address information. The ShipDtl table references the same ShipHead
record by Company and PackNum.

Let me know if you need more detail,

Dale Puls
Pacesetter Electronics

-----Original Message-----
From: Gary Grenier [mailto:ggrenier@...]
Sent: Tuesday, July 25, 2000 2:54 PM
To: vantage@egroups.com
Subject: [Vantage] RE: Ship To Limit


Dale,

What are you linking to (table(s)), and how? I have tried to do this here,
without much luck. I get time-out errors. When it would successfully
connect, I wouldn't always have the correct information.

Gary Grenier
Bell Manufacturing Co.
ggrenier@...

> You might take a look at UPS's Worldship. I use an ODBC link to get the
> information from Vantage. This way we only keep one copy of all addresses
in
> Vantage. There is never a case where the information is incorrect because
> there are multiple copies.
>
> Dale Puls
> Pacesetter Electronics