So our current setup has a channel with a playa field. This worked well so far BUT now we need to store specific values for each relationship (eg: The related field will need a catalogue number, specific price etc so each child relationship can have unique values as well).
From the top of my head this could be achieved by creating a new matrix/grid field in the same channel with all those unique columns (playa relationship field, catalogue number, price, etc).
My questions is, would that be the best solution for this issue? If so, I'm guessing that a MySQL query with the right format should do the job?