Forum Discussion
Table Relationship Issues
Hello, I have a sales by serial number and claims by serial number table and the only common field is the serial number. Both tables can have the serial number listed more than once for various ...
Hello VasTg ,
Here is sample Claim Data:
Claim # Claim Date Claim Type Status Serial # Svc Agent Customer Fail Date Repair Date # Trips Labor Parts Other Total Claim 1 10/21/2019 Warranty Paid Serial 1 SA1 Cust1 10/15/2019 10/15/2019 1 237.2 0 0 237.16 Claim 2 12/22/2018 Installation Paid Serial 2 SA2 Cust2 12/13/2018 12/13/2018 1 216.6 0 20.49 237.12 Claim 3 5/17/2019 Warranty Paid Serial 2 SA2 Cust2 5/14/2019 5/14/2019 1 250 0 0 250 Claim 4 8/22/2019 Warranty Paid Serial 2 SA2 Cust2 8/16/2019 8/16/2019 1 286.2 47.56 4.76 338.48 Claim 5 9/1/2019 Installation Paid Serial 3 SA5 Cust3 8/16/2019 8/16/2019 1 629.2 510 51 1190.12 Claim 6 10/1/2019 Warranty Paid Serial 3 SA5 Cust3 10/1/2019 10/1/2019 1 100 200 50 350 Here is sample TransactionData:
BRAND Invoice Date Sales # Model # ITEM_DESC Qty SERIAL_NBR WIDGIT 5/20/2019 S123 Model 1 Unit XYZ 1 Serial 1 WIDGIT 11/29/2017 S123 Model 2 Unit XYZ 1 Serial 1 WIDGIT 11/29/2017 S125 Model 3 Unit XYZ 1 Serial 2 WIDGIT 9/20/2019 S125 Model 4 Unit XYZ 1 Serial 2 WIDGIT 9/20/2019 S127 Model 5 Unit XYZ 1 Serial 3 WIDGIT 10/15/2019 S127 Model 6 Unit XYZ 1 Serial 4 Thank you