Which display column would you use to get the total value shipped from OrderDtl?
--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Your key two tables will be OrderRel and ShipDtl
>
> Then link the following tables:
> * ShipDtl to ShipHead - You will need ShipHead to get the Ship Date
>
> * OrderRel to OrderDtl - You may need OrderDtl if you want to
> associate a $ value to the shipment
>
> * OrderDtl to OrderHed - You will need OrderHed to get the CustNum
>
> * OrderHed to Customer - You will need Customer to get the Customer Name
>
> Thanks
> Patty Buechler
>
>
>
> --- In vantage@yahoogroups.com, "Joel Kolling" <jkolling@> wrote:
> >
> > I'm trying to write a BAQ to give me order information and shipping
> > information if the order has shipped. I'm having problems linking the
> > Order and Shipping tables as I can't the Shipping details to come over.
> > Anyone have insight on how to link these together?
> >
> >
> >
> >
> >
> > Joel Kolling
> > IT Manager
> > ITC Manufacturing, Inc.
> > Phone: 602-648-0021
> > Cell: 480-861-2009
> > Fax: 602-415-1444
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>