Vantage 6.1 Reports Primary Keys and the ShipTo table

--- In vantage@yahoogroups.com, "Josh Holman" <jholman@...> wrote:
>
> 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.
>


Never mind I figured it out. It's a composite key CustNum and
ShipToNum.
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.