You can perform searches on materials in the active database within the current group and filter and modify their properties, (item code, description, and SKEY) and attributes (standard, weight, material, rating, or schedule) according to a set of user-defined criteria. This user-defined criteria is called a modifier definition and is created using the Modifier Builder.
The Modifier Builder is available only when the Materials tab in the Database window is active
-
Click the Material tab in the Database window, and then click Modify
.
-
On the Modifier tab, type a name for the filter in the Name box.
-
Use the options on the Property and Attribute tabs to build up the modifier definition. As you add clauses to build the modifier, the tree view updates to display the overall structure.
-
To add a clause to the definition, click Add.
-
Adding multiple modifiers of the same type but with different values results in an OR statement.
-
Adding multiple modifiers of different types results in an AND statement. For example, you can modify the ItemGroup property and the Weight attribute.
-
-
Do one of the following:
-
To run the modifier on all the materials in the database within the current group and filter, click All.
-
To step through the materials that meet the search criteria one-by-one, click Find Next and then click This to modify the selected material.
-
-
Naming a modifier is recommended only if you intend to save the modifier definition on the local computer for future use. If you prefer, you can create modifier definitions and run them against the current database on an ad hoc basis.
-
Materials do not display as modified in the main tree view until you have closed the Modifier Builder.
-
To save the modifier for future use, click Save on the Modifier tab.
-
The search and replace options available in the Modifier Builder are nearly identical to those available in the Find and Modify dialog box.