Thanks Todd and Sarah. I was having a senior moment and couldn't
remember the table name.
Already laid a shipping report by job number on the Ops Officers desk.
Cliff
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Cliff Drumeller
Sent: Friday, February 10, 2006 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Link Report
My Sales orders are linked to jobs. What tables do I use to produce a
report that shows a sales order and the job number it is linked to;
Sales Order # Job Number
11233334 xxxxxxxxxx
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 348
408 314 7420 cell
[Non-text portions of this message have been removed]
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
Yahoo! Groups Links
remember the table name.
Already laid a shipping report by job number on the Ops Officers desk.
Cliff
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Cliff Drumeller
Sent: Friday, February 10, 2006 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Link Report
My Sales orders are linked to jobs. What tables do I use to produce a
report that shows a sales order and the job number it is linked to;
Sales Order # Job Number
11233334 xxxxxxxxxx
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 348
408 314 7420 cell
[Non-text portions of this message have been removed]
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
Yahoo! Groups Links