--- 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?
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> >
>
Jose C Gomez
T: 904.469.1524 mobile
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't seem to be cleanly linking. Any advice?<br>
</div> <div style="color:#fff;min-height:0;"></div>
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?
> >
> >
> >
>
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Wed, Dec 18, 2013 at 11:19 AM, clederer@... <clederer@...> wrote:
Â<div> <p>PartTran --> 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>
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?
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>