General Fastener Database FieldsKeyCreator \ Advanced-Customization \ Databases \ General-Fastener-Database-Fields
General Fastener Database Fields
General Database Fields (*Not used for Nuts and Washers)
The TYPE, PARTNUM and DASH fields are Key Fields that are used to build the hierarchical structure of the database. When creating a fastener, the program will scan the database file and create a Type list of all unique Types that are found. For each Type, a Size list of unique Part Numbers will be made. The DASH field is used as the unique Key Field from which the Length list is made. Note that the program can be configured instead to display the decimal values taken from the SIZE and LNG fields in the Size and Length lists, respectively. In this case, these lists are still built from unique PARTNUM and DASH records in the database.
KeyCreator comes with sample part numbers in the PARTNUM field. You may, if necessary, replace the sample part numbers with your company's own part numbers. Remember that all fasteners of a specific type must have a unique part number (e.g., no two hex bolts can have the exact same part number).