MGI ID and Other Field Requirements
The "MGIIDFIELD" is expected to be an ever-increasing number that is always in ascending order. If you are populating this field manually, you are responsible for keeping these numbers in order (which is possibly automatable with an mgiCounter using mgiModifyDatabase but not automatable inside mgiEditDatabase). Numbers can be missing from the order (i.e. 1, 2, 3, 5, 9, 132) due to the deletion of records, but no number can be less than the "MGIIDFIELD" value of the previous record.
An ODBC database must contain at least one field at all times. If a user wants to delete the "MGIIDFIELD" that was added by default, they must first create another field.