Forum Discussion
szub
Helper III
Helper IIITable 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 ...
szubHelper III
Helper IIIHello 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