Job Prod table

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.

--- 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]
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]
Do you have any programmers on staff?

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, March 13, 2006 3:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Job Prod table


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/.
(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
yep and they are even more confused than I am!

I tried to explain aliases to them, but they are thinking the info should be
passed from the JobHead table.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Frank Zeigafuse
Sent: Monday, March 13, 2006 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Prod table


Do you have any programmers on staff?

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, March 13, 2006 3:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Job Prod table


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/.
(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









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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
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]
I had my programmers work on an app close to this.

It look for sales orders of parents given a child.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, March 13, 2006 4:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Prod table


yep and they are even more confused than I am!

I tried to explain aliases to them, but they are thinking the info
should be passed from the JobHead table.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Frank Zeigafuse
Sent: Monday, March 13, 2006 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Prod table


Do you have any programmers on staff?

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, March 13, 2006 3:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Job Prod table


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/.
(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









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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&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
da+database+ng+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
turing+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&k=Database+mortgage+software&w1=Manuf
actu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
ring+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&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
a+database+g+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
turing+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&k=Database+marketing+software&w1=Manu
fact
uring+software&w2=Membership+database+software&w3=Database+mortgage+soft
uring+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/.
(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
Sound like you need to create 9 alias tables to go along with your
original and arrange your recursive joins in a daisy chain.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, March 13, 2006 3:46 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Job Prod table



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 software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



________________________________

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]
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]
>
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/.
(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&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
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]
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&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&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&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&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&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&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]