I have a nested structure like this:
REPAIR ORDER 1 / John Doe / 2024 Charger
INTERVENTION 1 / Engine Noise
POSITION 1 / Labor
POSITION 2 / Bearing
INTERVENTION 2 / Tyre Change
POSITION 1 / Labor
POSITION 2 / Michelin Tyres
REPAIR ORDER 2 / Williams O'Sullivan / 2023 Corolla
INTERVENTION 1 / Wheel alignment
POSITION 1 / Labor
So there are three tables, REPAIR ORDER (RO), INTERVENTION (IN) and POSITION (PO).
Here are example tables (in production I import them from a as400/ibmi via a c# script via a created c# odbc/dataverse connector):
REPAIR ORDER (RO)
ROKEY | Customer | Vehicle |
---|---|---|
1 | John Doe | 2024 Charger |
2 | Williams O'Sullivan | 2023 Corolla |