changing a one to one left join to a many to one ?

[jamie]

Is this sort of thing even possible?

In the past, someone set up the relationship, and we now have a lot of data relying on it, but our database has just grown too big, so our query time has exceeded the timeout point, and we need to change it, but we don't want to lose data

Thanks for all the help and even snide remarks

[emillod]

It's possible to change it via files. Proper change should be applied via entityDefs directory, BUT it require also adjustments in database, so there should be a script which will adjust data. It's possible, but it's tricky and without skills may cause data loss.