How to change Forgien key constriant

How to change Forgien key constriant


As off we have 2 table First is Master and other is Director Table first requirement is Only one Director agian every Master Entriy but Now Some Requirment is Change Like Master has multiple Director then we required to chagen Entity Structure so now director table required forgien key of master table when we try to chage in table the that gives error
"Publishing Error Unable to upgrade database schema. Error trying to create foreign key on database field 'OSUSR_90p_EIDRDirectors.EIDRENTRIESID'."
Kindly suggest how to solve this error.

Hi there!

I believe you can start from the original version of your module, delete the existing relationship, add a new attribute and set it as a foreign key.

This should allow you to publish just fine...