Thanks to both of you for your replies. After posting my question I
did try another route and that worked. I had hoped to make it
simpler by using the Calculated field CustID in the JobHeader table
but I guess that must not be possible.
What I did was link the OrderHead table to the Job Ship Table then
the Customer Table to the OrderHead table.
Brian Stenglein
did try another route and that worked. I had hoped to make it
simpler by using the Calculated field CustID in the JobHeader table
but I guess that must not be possible.
What I did was link the OrderHead table to the Job Ship Table then
the Customer Table to the OrderHead table.
Brian Stenglein
--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Don't forget that company = company needs to be in every
relationship.
>
> It appears that custnum is not in any of the tables in your Data
> Definition.
>
> This is what I would do:
>
> 1. Add table CustXPrt
> 2. Add relationship Parent Table JobPart to Child Table CustXPrt.
> JobPart.Company = CustXPrt.Company
> JobPart.PartNum = CustXPrt.PartNum
> 3. Now add table Customer.
> 4. Add relationship Parent Table CustXPrt to Child Table Customer.
> CustXPrt.Company = Customer.Company
> CustXPrt.CustNum = Customer.CustNum
>
> That should work to get information from your Customer table onto
> your Job Traveler form.
>
> If you are following the steps in Epicor's AnswerBook #
4778MPS, "CR
> Modifying a Crystal Report form in V8.xx", you shouldn't get any
> errors. You can download Answerbooks free from the Epicor website
by
> logging on and searching for them in the Epicor Search field.
>
> Lynn
>
>
> --- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@> wrote:
> >
> > You want to find the field CustNum...not custID. That will help
> link
> > your tables.
> >
> > Look at the other tables available in the definition for this
link.
> >
> > HTH,
> >
> >
> >
> > M. Manasa Reddy
> > manasa@
> > P: 630-806-2000
> > F: 630-806-2001
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Brian Stenglein
> > Sent: Thursday, October 16, 2008 2:02 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Modifying Report Data Definition for Job
Traveler
> >
> >
> >
> > I am trying my first modification to a "Crystal Form" in
8.03.400,
> the
> > Job Traveler. We have some customer specific notes in the
Customer
> VB
> > form fields Character02 and Character03 that we have printing on
> our
> > Vantage 6.1 Traveler. I need to get that data on the 8.03.400
> > Traveler. I have created a custom copy of the Traveler and the
> Report
> > Data Definition. I've figured out how to add a field (BubbleNum)
> from
> > a table (JobMtl) that already existed in the definition. Now I
need
> to
> > add a table (Customer) to the definition.
> >
> > The JobHead table contains a calculated field for CustID that I
was
> > hoping to be able to use to link to the Customer table. I'm not
> sure
> > if it's possible to link with a calculated field or not, but when
I
> > added the customer table and added a relationship and tried to
> chose
> > the relationship field CustID isn't available.
> >
> > How would you advise linking the Customer Table to the Job
Traveler?
> >
> > Thanks,
> >
> > Brian Stenglein
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>