MGI ID and Other Field Requirements

MGIIDFIELD 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.

Field Deletion

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.

[Return to the Using ODBC Databases Menu]

[Understanding MGI Menu] [Using MGI Menu] [Referencing MGI Menu]

[MGI Guides Main Menu] [User Guide Main Menu]