When assigning a part number to a device, some of the part numbers listed on the Select Part Number dialog do not match the filter, and some part numbers that should be listed are missing.
In a particular case, the default filter was cleared and changed to "Part Number like ABC*", but the resulting list did not include two recently added part numbers beginning with "ABC" while it included two part numbers that did not begin with "ABC". These non-matching part numbers appeared in the list where the two new part numbers should have, if sorted alphabetically. When the same filter is applied in the Parts Database Manager, the results are correct. Using Show Differences did not help. Same problems occurred in a brand new project. Creating and using a new parts database path did not help.
For this particular case, when the parts database was opened in Microsoft Access, the OID field contained duplicate values even though the data type for the field is AutoNumber. The value in the OID field for part numbers that appeared incorrectly in the Select Part Number dialog matched the value for the respective part numbers thatincorrectly did not appear.
AutoNumber fields cannot be renumbered. To correct duplicate values in the OID field use the following process:
Keywords: 39522, 500000066121