--- In vantage@yahoogroups.com, "Josh Holman" <jholman@...> wrote:
ShipToNum.
>Never mind I figured it out. It's a composite key CustNum and
> Hello all. I have been having the worst time in crystal getting a
> report done. I think its because of my innability to understand the
> keys used in the Shipto table.
> It seems that if no ShipTo is entered for a client their main address
> goes in the ShipTo table with a blank ShipToNum so for a report I've
> written that includes links between the InvcDtl.ShipToNum and the
> ShipTo.ShipToNum. I get either all ship to addresses for the customer
> ID or in some cases all shipto address for the whole database. My
> report contains the InvcHead, InvcDtl, Customer, and ShipTo tables. I
> want to output invoice data which works fine but also the shipping
> data. Can anyone help me with what to link so I dont get 70 pages of
> responces because the ShipToNum of the invoice was blank.
>
ShipToNum.