Tuesday, September 19, 2017

Starting ID

By default Parts uses the ID field as the Primary Key. The application also supports using company part numbers for the Primary Key.

When the primary key is not a Mfr Part Number or a Company Part Number you will be able update components in the schematic with another Mfr Part Number or a Company Part Number if needed.

This unique ID key provides greater level of flexibility than a company part number key.

Selecting the New or Make Like command increments the ID to the next higher ID number.

The ID key is not restricted to being only the next higher number. If desired the librarian can unlock the ID field and enter a number for the ID.

The only restriction is that the ID number can not already be in use because the primary key is a unique number. Duplicate IDs are NOT allowed in the Parts database.

The Parts demo has a default starting number a 30000, however if you want start your database at a lower number like 10000 you can delete all the records then select New and enter your desired starting number.


To delete all records, press Ctrl + A, then press the delete key on your keyboard.

You can also use Tools > Export Excel, renumber the IDs in Excel, then Tools > Import Excel.

To prevent breaking links in existing projects IDs should not be changed after components have been placed in a design.

Using a five or six digit starting number will create nice looking ID numbers.

For example (recommended):

30000
30001
30002

30003

30004

While starting at 1 would create IDs like (not recommended):

1
12
103
1001
10000

It's your choice, however I recommend starting at 30000. This will allow for records to be added as needed with IDs below 30000 or higher than the highest ID used in the database.

Note: There is an option in the Frontend Configuration to keep the ID locked. This lock can be used to prevent users from tampering with the unique ID keys.

That's it !

No comments: