2011

Table Of Contents
Specify the table to create and click Create or select the table to edit and click
Edit.
This lookup database table is a table within the catalog lookup Access .mdb
file. The default file name is default_cat.mdb, table _PINLIST, and comes
populated with a sample of vendor data. You can expand this table as needed.
Use your own copy of Microsoft Access or this dialog box to add new entries,
add entries based on existing entries, edit, and delete entries from the table.
Sorts the list of database records using either an alphanumeric sort
or number values. You can specify four sorts to perform on the list.
Sort
Sorts the list of database records using either an alphanumeric sort
or number values. You can specify four sorts to perform on the list.
Find
Indicates to replace the find value with the new text string that you
specify.
Replace
Filters the listing based on certain values in the table. Picking the
blank entry in the list removes the filter for that field. After you define
the values to filter, apply the filter in the database editing window.
Filter
Displays the Edit Record dialog box for modifying the existing record
in the database.
Edit
Displays the Edit New Record dialog box for entering a new record
into the database.
Add New
Displays the Edit Copied Record dialog box for modifying and copying
the record to make a new record. You cannot have two duplicate
copies in the database.
Add Copy
Removes the selected record from the database.Delete
Structure of the pin list database table
(Microsoft Access internal use)RECNUM
Manufacturer code (value must be consistent with the
catalog lookup files)
MANUFACTURER
Catalog number (use wildcards as much as possible)CATALOG
1308 | Chapter 17 BOM and Catalogs