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