Have you seen any videos on relations yet?
It seems to me that your machines table needs a comma separated list of parts.
Then:
- Use a split text column to turn the parts list column into an array
- Use a relation column (set to match multiple) to relate the array column to the spare parts table —> matching spare part column
- Somewhere on the details screen for the machine, display a collection pointed to the relation of spare parts
4 Likes