Basically what all of you are saying is that I have to go the route of
aliases....I guess I'll just have to beat them over the head to do this.
Doug, I did like your idea...I may just get them to that with the next ship
set!
Thanks to everyone who responded!
Manasa
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Gerard Wadman
Sent: Tuesday, March 14, 2006 7:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Prod table
Perhaps JobProd.TargetJobNum to Jobprod2.JobNum or visa versa
The last level will have a null value in the target job number column so
you would have to use outer joins.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Tuesday, March 14, 2006 7:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Prod table
But I need job numbers, not just part numbers.....
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Ace_Man
Sent: Monday, March 13, 2006 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Prod table
Sound like the Where Used... If it is, then Part table linked to
PartMtl table by:
Part PartMtl
Company-->Company
PartNum-->MatlPartNum
Then link PartMtl table with PartMtl2 (alias) by:
PartMtl PartMtl2
Company------>Company
PartNum------>MtlPartNum
Keep doing the same process to however many levels you need.
Hope this helps.
aliases....I guess I'll just have to beat them over the head to do this.
Doug, I did like your idea...I may just get them to that with the next ship
set!
Thanks to everyone who responded!
Manasa
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Gerard Wadman
Sent: Tuesday, March 14, 2006 7:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Prod table
Perhaps JobProd.TargetJobNum to Jobprod2.JobNum or visa versa
The last level will have a null value in the target job number column so
you would have to use outer joins.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Tuesday, March 14, 2006 7:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Prod table
But I need job numbers, not just part numbers.....
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Ace_Man
Sent: Monday, March 13, 2006 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Prod table
Sound like the Where Used... If it is, then Part table linked to
PartMtl table by:
Part PartMtl
Company-->Company
PartNum-->MatlPartNum
Then link PartMtl table with PartMtl2 (alias) by:
PartMtl PartMtl2
Company------>Company
PartNum------>MtlPartNum
Keep doing the same process to however many levels you need.
Hope this helps.
--- In vantage@yahoogroups.com, "Manasa Reddy" <mmreddy@...> wrote:
>
> Guys I have a big issue and I am hoping someone out there can
point me in
> the right direction.
>
> I want to write a report showing all of the jobs that are linked
to my
> parent job (meaning the part
> we ship out to the customer). Here is the problem, my parent part
can have
> an indented BOM
> 10 levels or more. We create the sub assemblies on separate jobs
that are
> all interconnected to
> each other up to the parent part (also on a separate job) as job
material.
>
> I'm trying to use the jobprod table, but whenever I do this I only
get the
> next level not all levels.
>
> Anyone tried to do what I am looking for? Did you succeed? Would
you be
> willing to share?
>
>
> M. Manasa Reddy
> ERP Systems Specialist
> Crestview Aerospace Corporation
> Email: mmreddy@...
> Phone: (850) 682-2746 x 272
>
>
>
>
>
> [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/.
<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
SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu>
&k=Manufacturing+software&w1=Manufactu
ring
+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=P
da+database+software&w5=Database+management+software&w6=Database+marketi
ng+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man>
&k=Membership+database+software&w1=Man
ufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf>
&k=Database+mortgage+software&w1=Manuf
actu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&
w4=Pda+database+software&w5=Database+management+software&w6=Database+mar
keti
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur>
&k=Pda+database+software&w1=Manufactur
ing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w
4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketin
g+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man>
&k=Database+management+software&w1=Man
ufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu>
&k=Database+marketing+software&w1=Manu
fact
uring+software&w2=Membership+database+software&w3=Database+mortgage+soft
ware
&w4=Pda+database+software&w5=Database+management+software&w6=Database+ma
rket
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <http://groups.yahoo.com/group/vantage>
"
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
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/.
<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
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
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
* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]