Filtering values can be defined differently for each Catalog Lookup table. The first field defines the Catalog Lookup table name. The next fields follow the same format and order as the Catalog Lookup table structure. Leave the field blank if you do not want to filter the records based on the values in that field. Access automatically handles the last field, which is the record number.
- When the Parts Catalog dialogue box displays, the program checks to see if the component already has a Catalog defined.
- If no Catalog is defined, the program checks the _LISTBOX_DEF table for a record with a TABLENAME value that matches the table name for the component.
- If a TABLENAME match is found, the program filters the records displayed in the Parts Catalog dialogue box using the non-blank values from the _LISTBOX_DEF record.