OrderRel join question

Mike:

Save yourself some time. Try my report.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Tuesday, October 23, 2001 10:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OrderRel join question

Good Evening,

I'm writing a report that pulls much of the same information as the
Scheduled
Shipments Report. However, when I try to join the OrderRel to ShipTo tables
I
notice that the Shiptonum is there but the CustNum is not. Am I missing
something here?

If not, any suggestions on how to get the Order Release ship to information
on
this report? I can't use the Order Head ship to information as many of the
releases have different ship to's.

Thanks!

Mike Lowe
Connor




Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=212180.1660613.3195489.1269402/D=egroupweb/S=17050071
83:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
Good Evening,

I'm writing a report that pulls much of the same information as the Scheduled
Shipments Report. However, when I try to join the OrderRel to ShipTo tables I
notice that the Shiptonum is there but the CustNum is not. Am I missing
something here?

If not, any suggestions on how to get the Order Release ship to information on
this report? I can't use the Order Head ship to information as many of the
releases have different ship to's.

Thanks!

Mike Lowe
Connor
Use the CUSTNUM field from the OrderDtl table or the OrderHed table to make
your join.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a


-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Tuesday, October 23, 2001 9:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OrderRel join question


Good Evening,

I'm writing a report that pulls much of the same information as the
Scheduled
Shipments Report. However, when I try to join the OrderRel to ShipTo tables
I
notice that the Shiptonum is there but the CustNum is not. Am I missing
something here?

If not, any suggestions on how to get the Order Release ship to information
on
this report? I can't use the Order Head ship to information as many of the
releases have different ship to's.

Thanks!

Mike Lowe
Connor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/