If I have an existing One to Many Database Collection and I want to change it to a Many to Many, how is that done in Adalo?
Hi @HughG,
Welcome to the community 
You mean that you have created a One to Many relationship with 2 collections and now you want to change that relationship to a Many to Many relationship without creating a new one?
As far as I’m aware it’s not possible, unfortunately! ( You could add this here ) What you can do is delete that One to Many relationship and create the new Many to Many relationship!
Thank you
1 Like
Thanks. It’s good to be here… loving Adalo… it really is awesome.
Ok, so, I am developing a customer company based product management solution and so, it could be the case whereby for one customer, they would only want a One to Many relationship between table A and table B, but another might want a many to many between A and B. So in other words apart from the Many to One (lookups… which are often obvious) all other relations in my Collections/Tables should be Many to Many, and then the customer that only needs the One to Many can then simply link just the one Collection item/table record to the Many item/table record… if you see what I mean 
