I’m encountering the issue again. It’s happens when adding a reference field while using the Advanced view in the Database Manager. Advanced view exposed some properties (allow null, unique, & primary key) in the field properties section that do not show in Basic view.
Sequence of events.
- I tried to add the field in Advanced view and got the error
- Switched to Basic view and it worked.
But here’s the weird part. I then switched back to Advanced view to attempt to add another field and the field properties no longer showed the extra properties (allow null, unique, & primary key), but I still received the error when I tried to apply the database changes.