For whatever reason that was causing 1-2 jobs out of 1000 not to appear, has been fixed.
I'm using the tables OrderHed -> QuoteHed -> JobProd -> Customer
tables. Had to create a special link for the OrderDtl.QuoteNum->QuoteHed.QuoteNum table since the OrderDtl.QuoteNum doesn't contain all the QuoteHed.QuoteNum information.
Just thought I'd update my POST.
Thanks,
--sf
I'm using the tables OrderHed -> QuoteHed -> JobProd -> Customer
tables. Had to create a special link for the OrderDtl.QuoteNum->QuoteHed.QuoteNum table since the OrderDtl.QuoteNum doesn't contain all the QuoteHed.QuoteNum information.
Just thought I'd update my POST.
Thanks,
--sf
--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
>
> Thank you for the response. Actually, I did link the OrderDtl->QuoteDtl, and had success, but there were the rare abnormalities when the a job # would not display, and that was not acceptable to our planners.
>
>
>
> --sf
> --- In vantage@yahoogroups.com, Linda Lowney <llowney@> wrote:
> >
> > Try linking JobHed -> JobProd -> OrderDtl . You can pick up the quote number from OrderDtl.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanfranc415
> > Sent: Thursday, November 10, 2011 11:32 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Quote number on Job Traveler?
> >
> >
> >
> > What about a Crystal report using ODBC to connect to the database? I've tried linking the two tables, but there are no relationships in QuoteHed and JobHed to link.
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@> wrote:
> > >
> > > You can bring in the quote number pretty easily, the JobHead and QuoteHed tables are naturally related.
> > >
> > > Ted
> > >
> > >
> > >
> > > ________________________________
> > > From: sanfranc415 <sanfranc415@>
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, November 9, 2011 4:36 PM
> > > Subject: [Vantage] Quote number on Job Traveler?
> > >
> > > Anyone using a Job Traveler that includes the Quote Number?
> > >
> > > Thanks,
> > >
> > > ---sf
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > 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/linksYahoo! Groups Links
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>