Linking an UD table to PartRev

I want it to show up as a Tab in the Part Maintenance's Revisions tab.



Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, May 14, 2012 10:34 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Linking an UD table to PartRev

Do you want it to show on the UI? Or just be in the data fro reporting?

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, May 14, 2012 at 1:30 PM, Marco Vissuet <mvissuet@...
> wrote:

> **
>
>
> We are on 9.05.606.
>
> When Engineering creates master methods for a revision, often they
> combine the planning for several parts together. Part1 has the
> planning for Part1, Part2, Part3.
>
> We want to link a UD table to the part rev table so that they can list
> all the combined parts.
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part2
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part3
>
> Marco Vissuet
> Systems Engineering
> Pacific Contours Corporation
> Office (619) 670-3900
> Fax (619) 670-1643
> marcov@...
> http://www.pacificcontours.com/
>
> "The information contained herein may be subject to the International
> Traffic in Arms Regulations (ITAR) Warning: - This document contains
> data whose export is restricted by the Arms Export Control Act (Title
> 22, U.S.C., Sec 2751, et seq.) as amended, or the Export
> Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended.
> Violations of these export laws are subject to severe criminal and
> civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Monday, May 14, 2012 10:18 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Linking an UD table to PartRev
>
> You need more details here my friend,
>
> What version are you on? 9xx? If so you can do it simply through a
> customization, you need to pick which fields in UDX map to PartREv
> something like UDX.Key1=PartRev.PartNum, UDX.Key2=PartRev.RevNum etc...
>
> Give us a bit more details so that we know exactly what youa re trying
> to do.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, May 14, 2012 at 1:09 PM, supertico05
> <mvissuet@...>wrote:
>
> > **
>
> >
> >
> > How do you link the table UD01 to the PartRev table... so that the
> > UD01 is a child table to PartRev?
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
>


[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/linksYahoo! Groups Links
How do you link the table UD01 to the PartRev table... so that the UD01 is a child table to PartRev?
You need more details here my friend,

What version are you on? 9xx? If so you can do it simply through a
customization, you need to pick which fields in UDX map to PartREv
something like UDX.Key1=PartRev.PartNum, UDX.Key2=PartRev.RevNum etc...

Give us a bit more details so that we know exactly what youa re trying to
do.



*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, May 14, 2012 at 1:09 PM, supertico05
<mvissuet@...>wrote:

> **
>
>
> How do you link the table UD01 to the PartRev table... so that the UD01 is
> a child table to PartRev?
>
>
>


[Non-text portions of this message have been removed]
We are on 9.05.606.

When Engineering creates master methods for a revision, often they combine the planning for several parts together. Part1 has the planning for Part1, Part2, Part3.

We want to link a UD table to the part rev table so that they can list all the combined parts.


UD01.Key1 = PartRev.PartNum
UD01.Key2 = PartRev.RevisionNum
UD01.Key3 = PartRev.AltMethod
UD01.ShortChar01 = part2

UD01.Key1 = PartRev.PartNum
UD01.Key2 = PartRev.RevisionNum
UD01.Key3 = PartRev.AltMethod
UD01.ShortChar01 = part3



Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, May 14, 2012 10:18 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Linking an UD table to PartRev

You need more details here my friend,

What version are you on? 9xx? If so you can do it simply through a customization, you need to pick which fields in UDX map to PartREv something like UDX.Key1=PartRev.PartNum, UDX.Key2=PartRev.RevNum etc...

Give us a bit more details so that we know exactly what youa re trying to do.



*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, May 14, 2012 at 1:09 PM, supertico05
<mvissuet@...>wrote:

> **
>
>
> How do you link the table UD01 to the PartRev table... so that the
> UD01 is a child table to PartRev?
>
>
>


[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/linksYahoo! Groups Links
Do you want it to show on the UI? Or just be in the data fro reporting?

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, May 14, 2012 at 1:30 PM, Marco Vissuet <mvissuet@...
> wrote:

> **
>
>
> We are on 9.05.606.
>
> When Engineering creates master methods for a revision, often they combine
> the planning for several parts together. Part1 has the planning for Part1,
> Part2, Part3.
>
> We want to link a UD table to the part rev table so that they can list all
> the combined parts.
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part2
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part3
>
> Marco Vissuet
> Systems Engineering
> Pacific Contours Corporation
> Office (619) 670-3900
> Fax (619) 670-1643
> marcov@...
> http://www.pacificcontours.com/
>
> "The information contained herein may be subject to the International
> Traffic in Arms Regulations (ITAR) Warning: - This document contains data
> whose export is restricted by the Arms Export Control Act (Title 22,
> U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act
> (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export
> laws are subject to severe criminal and civil penalties. Disseminate in
> accordance with provisions of DoD Directive 5230.25.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Monday, May 14, 2012 10:18 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Linking an UD table to PartRev
>
> You need more details here my friend,
>
> What version are you on? 9xx? If so you can do it simply through a
> customization, you need to pick which fields in UDX map to PartREv
> something like UDX.Key1=PartRev.PartNum, UDX.Key2=PartRev.RevNum etc...
>
> Give us a bit more details so that we know exactly what youa re trying to
> do.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, May 14, 2012 at 1:09 PM, supertico05
> <mvissuet@...>wrote:
>
> > **
>
> >
> >
> > How do you link the table UD01 to the PartRev table... so that the
> > UD01 is a child table to PartRev?
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]
Seems like a lot of work......
you cant use the ShortChar or Character fields of the PartRev record to record what you want?

and you would need to Use Key4 also in your UD table for the additional part numbers to keep the records unique....

--- In vantage@yahoogroups.com, Marco Vissuet <mvissuet@...> wrote:
>
> We are on 9.05.606.
>
> When Engineering creates master methods for a revision, often they combine the planning for several parts together. Part1 has the planning for Part1, Part2, Part3.
>
> We want to link a UD table to the part rev table so that they can list all the combined parts.
>
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part2
>
> UD01.Key1 = PartRev.PartNum
> UD01.Key2 = PartRev.RevisionNum
> UD01.Key3 = PartRev.AltMethod
> UD01.ShortChar01 = part3
>
>
>
> Marco Vissuet
> Systems Engineering
> Pacific Contours Corporation
> Office (619) 670-3900
> Fax (619) 670-1643
> marcov@...
> http://www.pacificcontours.com/
>
> "The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
> Sent: Monday, May 14, 2012 10:18 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Linking an UD table to PartRev
>
> You need more details here my friend,
>
> What version are you on? 9xx? If so you can do it simply through a customization, you need to pick which fields in UDX map to PartREv something like UDX.Key1=PartRev.PartNum, UDX.Key2=PartRev.RevNum etc...
>
> Give us a bit more details so that we know exactly what youa re trying to do.
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Mon, May 14, 2012 at 1:09 PM, supertico05
> <mvissuet@...>wrote:
>
> > **
> >
> >
> > How do you link the table UD01 to the PartRev table... so that the
> > UD01 is a child table to PartRev?
> >
> >
> >
>
>
> [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/linksYahoo! Groups Links
>