Linking the PART table to JOBMATL and JOBHEAD

Yahoo Archive
1
Susan,
Link as much as you can and finish the query. Then you can manually write
in the link (using the same format) in the query not using the tool.
I have had to use this method to link several tables that don't want to
link.
Let me know if you need more info.
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Susan Iverson
Sent: Tuesday, August 09, 2005 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Linking the PART table to JOBMATL and JOBHEAD
Importance: High


We need to set up a report that lists our jobs completed but we need
them by customer, plant, warehouse and we need to include the part table
to get a uom we created using number01 field. However, when testing this
report in BAQ before I write it in Crystal, I noticed that once you
select a job"anything" tables you no longer have access to the part
table (only other part tables that for us are not usable in this
report).



Have any of you had this problem? If so, what was your work-around?



Thank you,



Sue

Vantage 6.1





[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
2
We need to set up a report that lists our jobs completed but we need
them by customer, plant, warehouse and we need to include the part table
to get a uom we created using number01 field. However, when testing this
report in BAQ before I write it in Crystal, I noticed that once you
select a job"anything" tables you no longer have access to the part
table (only other part tables that for us are not usable in this
report).



Have any of you had this problem? If so, what was your work-around?



Thank you,



Sue

Vantage 6.1





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