Making a new Item Type Mandatory
Hello All,
So I have created 2 Lists (project_id & SystemLevel) and filled them with appropriate values. I have then added these to the list of properties in the Part Item Type. I then linked these t...
Forum Discussion
Hi there,
Are there any more thoughts on this?
I've tried to add a simple string field and make this mandatory only to get a similar message.:
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'TEST' cannot be added to non-empty table 'PART' because it does not satisfy these conditions. in SQL: ALTER TABLE [PART] ADD [TEST] NVARCHAR(12) NOT NULLDoes this mean that you cannot add and make mandatory any fields to the Part Item Type has been used to create Parts...?
