I have a very strange problem.
I have a table, ProspectClient. There is a field name PreferredMethod_id and a constraints link to PreferredMethod. This was fine actually.
The problem came in is when I changed field, PreferredMethod_id, to ContactMeBy_id, and remove the previous constraints and add another one to link to ContactMeBy table.
When I update the Entity Model. The field name changes was made but not the constraints part. No matter how I change the constraint name, remove and update, Add and update. it just doesn't show up as part of the Navigation.
I have no idea what to do now.