I would like to be able to extend the Many to Many tables, by having an advanced button/view to see them and extend them. (Similar to child record pages on Reports)
The idea would be that we cant delete the key fields or the table itself only by removing the connection as today but we could add field(s) so an example is a Companies table and a Location table, they need joining with a many to many (No problem Knack handles this) but to manage them they need a field to say what the Company does for that Location, so could be Owner, FM Company, e.t.c. and that is where we need to be able to extend the Many to many tables and have a UI to handle the extended field selection.
Would love this also, I really struggle with implementing things that rely on many-to-many relationships.