Define look-up items for use with Products
Look-ups are predefined constants that can be used in Formula in the Product and Part libraries and elsewhere. The table is used to define the Look-up items and set the constant value. At the main screen:-
● Select: Libraries - Look-up table
- Enter a look-up name, description, value and notes.
A Look-up is useful where the same item is used in a variety of products, for example, a back material of hardboard, but the specification may occasionally change. For example, a product may contain several parts with the same back material.
Part Qty Description Material Length Width
BU05mE/Bk 1 Base - Back $BACKMAT$ 585.0 870.0
BU05MR/BK 2 End unit - Back $BACKMAT$ 620.0 450.0
The same back material may be used in many different products. The effect of the Look-up when the Product requirements are calculated is to set the material to the value of the Look-up. In this case: HARDBOARD-4MM. The advantage of a look-up is that if the specification of the back material changes e.g. to PLYWOOD-4MM only the value in the look-up table has to be changed.
Save (the table is
saved to a database/library)
New
(also Return on the last line to create a
new line)
Delete (move to a line and
select Delete)
Print ('Print setup' and
'Print preview' are on the 'File' menu
Help
Exit
These options are also on the menus and on the 'Edit' menu are the usual 'Cut, Copy, Paste' options); 'Find' to locate an item; 'Insert line' to add a line between other lines.
There are many other ways of using Look-ups - see the topic: Look-up table Walkthrough
Notes
- If the lookup name cannot be found the lookup is set to blank but the rest of formula is evaluated in the usual way.
- In a formula each lookup much contain a pair of $ symbols to mark the lookup; otherwise the symbols are taken as ordinary characters.
