Bug Issue when default value is missing
With the new designer it is not possible to change the default value when the value is not anymore in the list of values of the lookup.
Create a lookup field, then add a value in the list of value and setup a default value in the field. Delete the lookup value in the list then when saving the record you get an integrity error : The INSERT statement conflicted with the FOREIGN KEY constraint ...
In earlier version you were able to change the default value in the designer but now it is not possible anymore when changing the value you got the load turning and you cannot change the default value.
It would be a great idea to apply a change and not to have to go in the db for changing the Foreign key.