ElectedOfficals - Linked Action m2m should be a FK
We did a big mistake when setting up the ElectedOfficialContact model
- The field linking the contact to the Actiongroup is a m2m field
- This creates a bunch of issues, especially when trying to retrieve info when sending the email
We need to change from M2M to FK without loosing data, but m2m fields and FK are not compatible;
when testing `alterfield` in migration we get the error
ValueError: Cannot alter field risefor_lobbying.ElectedOfficialContact.linkedAction into risefor_lobbying.ElectedOfficialContact.linkedAction - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields)
Here is a step by step in order to make the transition
https://stackoverflow.com/questions/54704869/django-how-to-migrate-from-manytomany-to-foreignkey