Connecting UD01 table in a BAQ

No I do not, how would I go about doing that?

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> Do you have Part Number setup as a key in table UD01?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of clederer@...
> Sent: Wednesday, December 18, 2013 10:36 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Connecting UD01 table in a BAQ
>
>
>
> I'm trying to combine 2 separate queries into 1 query.
> 1. Part & PartTran
> 2 UD01
>
> I'm not sure if I'm looking to get the full contents of UD01 in every PartTran record
>
> --- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@<mailto:jose@>> wrote:
> >
> > Company shouldn't be your only key generally speaking ... or you'll get the
> > full contents of UD01 in every PartTran record... is taht what you want?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> >
> >
> > 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 Wed, Dec 18, 2013 at 11:19 AM, clederer@ <
> > clederer@> wrote:
> >
> > >
> > >
> > > PartTran --> Part
> > > Keys: Company & PartNum (Connects fine)
> > >
> > > UD01--> PartTran
> > > key: company (this didn't seem to connect it correctly)
> > >
> > > UD01--> Part
> > > key: company (this didn't seem to connect it correctly)
> > >
> > > My other thought is to connect the "SysRowID" between the UD01 tabel or
> > > Part/PartTran
> > >
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@> wrote:
> > > >
> > > > What do you mean... connect UD01 to PartTran.. or Part you'll need the
> > > keys
> > > > what keys are you using?
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > >
> > > >
> > > > 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 Wed, Dec 18, 2013 at 10:10 AM, clederer@ <
> > > > clederer@> wrote:
> > > >
> > > > >
> > > > >
> > > > > Trying to connect UD01 with PartTran or Part on company, but it doesn't
> > > > > seem to be cleanly linking. Any advice?
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> >
>
Trying to connect UD01 with PartTran or Part on company, but it doesn't seem to be cleanly linking. Any advice?
What do you mean... connect UD01 to PartTran.. or Part you'll need the keys what keys are you using?



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Wed, Dec 18, 2013 at 10:10 AM, clederer@... <clederer@...> wrote:

Â
<div>
  
  
  <p>Trying to connect UD01 with PartTran or Part on company, but it doesn&#39;t seem to be cleanly linking. Any advice?<br>

</div>
 


<div style="color:#fff;min-height:0;"></div>

PartTran --> Part
Keys: Company & PartNum (Connects fine)

UD01--> PartTran
key: company (this didn't seem to connect it correctly)

UD01--> Part
key: company (this didn't seem to connect it correctly)

My other thought is to connect the "SysRowID" between the UD01 tabel or Part/PartTran


--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> What do you mean... connect UD01 to PartTran.. or Part you'll need the keys
> what keys are you using?
>
>
> *Jose C Gomez*
> *Software Engineer*
>
>
> 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 Wed, Dec 18, 2013 at 10:10 AM, clederer@... <
> clederer@...> wrote:
>
> >
> >
> > Trying to connect UD01 with PartTran or Part on company, but it doesn't
> > seem to be cleanly linking. Any advice?
> >
> >
> >
>
Company shouldn't be your only key generally speaking ... or you'll get the full contents of UD01 in every PartTran record... is taht what you want?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Wed, Dec 18, 2013 at 11:19 AM, clederer@... <clederer@...> wrote:

Â
<div>
  
  
  <p>PartTran --&gt; Part<br>

Keys: Company & PartNum (Connects fine)



UD01–> PartTran

key: company (this didn't seem to connect it correctly)



UD01–> Part

key: company (this didn't seem to connect it correctly)



My other thought is to connect the "SysRowID" between the UD01 tabel or Part/PartTran





— In vantage@yahoogroups.com, Jose Gomez <jose@…> wrote:

>

> What do you mean… connect UD01 to PartTran… or Part you'll need the keys

> what keys are you using?

>

>

> Jose C Gomez

> Software Engineer

>

>

> 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 Wed, Dec 18, 2013 at 10:10 AM, clederer@… <

> clederer@…> wrote:

>

> >

> >

> > Trying to connect UD01 with PartTran or Part on company, but it doesn't

> > seem to be cleanly linking. Any advice?

> >

> >

> >

>


</div>
 


<div style="color:#fff;min-height:0;"></div>

I'm trying to combine 2 separate queries into 1 query.
1. Part & PartTran
2 UD01

I'm not sure if I'm looking to get the full contents of UD01 in every PartTran record



--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Company shouldn't be your only key generally speaking ... or you'll get the
> full contents of UD01 in every PartTran record... is taht what you want?
>
>
> *Jose C Gomez*
> *Software Engineer*
>
>
> 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 Wed, Dec 18, 2013 at 11:19 AM, clederer@... <
> clederer@...> wrote:
>
> >
> >
> > PartTran --> Part
> > Keys: Company & PartNum (Connects fine)
> >
> > UD01--> PartTran
> > key: company (this didn't seem to connect it correctly)
> >
> > UD01--> Part
> > key: company (this didn't seem to connect it correctly)
> >
> > My other thought is to connect the "SysRowID" between the UD01 tabel or
> > Part/PartTran
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > What do you mean... connect UD01 to PartTran.. or Part you'll need the
> > keys
> > > what keys are you using?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > >
> > >
> > > 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 Wed, Dec 18, 2013 at 10:10 AM, clederer@ <
> > > clederer@> wrote:
> > >
> > > >
> > > >
> > > > Trying to connect UD01 with PartTran or Part on company, but it doesn't
> > > > seem to be cleanly linking. Any advice?
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>

Do you have Part Number setup as a key in table UD01?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of clederer@...
Sent: Wednesday, December 18, 2013 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Connecting UD01 table in a BAQ

 

 

I'm trying to combine 2 separate queries into 1 query.
1. Part & PartTran
2 UD01

I'm not sure if I'm looking to get the full contents of UD01 in every PartTran record

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Company shouldn't be your only key generally speaking ... or you'll get the
> full contents of UD01 in every PartTran record... is taht what you want?
>
>
> *Jose C Gomez*
> *Software Engineer*
>
>
> 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 Wed, Dec 18, 2013 at 11:19 AM, clederer@... <
> clederer@...> wrote:
>
> >
> >
> > PartTran --> Part
> > Keys: Company & PartNum (Connects fine)
> >
> > UD01--> PartTran
> > key: company (this didn't seem to connect it correctly)
> >
> > UD01--> Part
> > key: company (this didn't seem to connect it correctly)
> >
> > My other thought is to connect the "SysRowID" between the UD01 tabel or
> > Part/PartTran
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > What do you mean... connect UD01 to PartTran.. or Part you'll need the
> > keys
> > > what keys are you using?
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > >
> > >
> > > 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 Wed, Dec 18, 2013 at 10:10 AM, clederer@ <
> > > clederer@> wrote:
> > >
> > > >
> > > >
> > > > Trying to connect UD01 with PartTran or Part on company, but it doesn't
> > > > seem to be cleanly linking. Any advice?
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>