Hi guys. Is it possible to update one to one relationship to one to many without destroying database? If so, how? Thank you guys.
I’m using v7.10.10
Probably, yes, but I’ve never done it. Try it on a test instance first!
To study the issue, I would use this technique to see what Studio does when creating a one-to-one, and then a one-to-many.
https://pgorod.github.io/Audit-File-Accesses/
Then examine the differences and try applying them manually, and run a Quick Repair and Rebuild. Make sure you scroll down to the bottom of the screen to see if it offers a button to “sync database with vardefs”.
Keep an eye on the database also: table fields_meta_data. You shouldn’t need to touch it, the QR & R should take care of that. But if you get misterious behaviours you might need to tweak something in there.
Please provide a tutorial with your findings, if you can get it working! Thanks!