Well I would hope so. Mind you, it's a one-to-many relationship. One Order Release can be shipped across multiple Packs. Not too sure of your typical biz model….
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 27, 2015 5:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Linking OrderDtl ShipDtl tables
Okay, when I do that the totals for my orders change significantly.
Good morning,
What's the proper way to link the OrderDtl(that includes OrderHed and OrderRel) with the ShipDTL table? I tried linking the OrderDtl.Line/Order/Rel with ShipDtl.Line/ORder/Rel, but the results are skewed.
Thanks.
You kind of answered your own question within your email below. You should not directly join OrderDtl directly to ShipDtl. You must link OrderRel to ShipDtl (OrderNum, OrderLine, OrderRelNum). Then link your OrderDtl and OrderHed to OrderRelNum
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 27, 2015 11:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - Linking OrderDtl ShipDtl tables
Good morning,
What's the proper way to link the OrderDtl(that includes OrderHed and OrderRel) with the ShipDTL table? I tried linking the OrderDtl.Line/Order/Rel with ShipDtl.Line/ORder/Rel, but the results are skewed.
Thanks.