Since it's a Job Traveler you're trying to modify, couldn't you relate them on JobNum and PartNum?
Ernie Lowell
Diba Industries
Ernie Lowell
Diba Industries
--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> You could maybe check if PartTran.TranNum matches the SNTran.TranNum
>
> --- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@> wrote:
> >
> > When a Part Transaction occurs (via Issue Material, etc), there's the option to attach a serial number to that transaction. In my Job Traveler, I want to show that associated Serial Number. Does that make sense?
> >
> > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > >
> > > Indeed, what are you actually looking to retrieve?
> > >
> > >
> > > On Tue, May 24, 2011 at 7:42 PM, Jose Gomez <jose@> wrote:
> > >
> > > > Not sure what SNTran does but it seems that both part tran and sn trans
> > > > have
> > > > a link to RMADtl, and FSCallDtl, JobAsmbl, DRMHead,
> > > >
> > > > Maybe through one of those? Not sure what you are tryinng to accomplish.
> > > >
> > > > *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/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > >
> > > > On Tue, May 24, 2011 at 7:36 PM, Jose Gomez <jose@> wrote:
> > > >
> > > > > Best advise I can give you is put one of the tables on a BAQ and display
> > > > > only liked, drag other related tables until you find a relationship. Then
> > > > > you can almost always remove some of the intermediate tables and still
> > > > make
> > > > > a relationship.
> > > > >
> > > > > I'll try and look for you but can't guarantee it!:)
> > > > > *
> > > > > *
> > > > > *
> > > > > *
> > > > > *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/>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > >
> > > > > On Tue, May 24, 2011 at 7:20 PM, cubcrafters_it <
> > > > > jason.navarrete@> wrote:
> > > > >
> > > > >>
> > > > >>
> > > > >> I'm trying to link tables back up in Crystal Reports...any idea what the
> > > > >> key is that links the SNtran and PartTran table? Or are those even the
> > > > right
> > > > >> tables to be linking?
> > > > >>
> > > > >> Can I look this kind of thing up myself? It seems like it ought to be
> > > > >> easier than it's turning out to be...support seemed to have no clue.
> > > > >>
> > > > >> Ideas?
> > > > >>
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > > [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]
> > >
> >
>