7
3. Lookup and Update. If you want to update existing worksheet data,
check the Lookup on Field box. Otherwise, skip to item 8. If you do
use the Lookup feature, Field 1 will be the lookup index field to
serve as the lookup reference.
The "Lookup Index" is what KwikCountRF uses to locate the correct
row to place updated data and find data to display (in non-index
columns). If you want to do lookups, all of your range specifications
must start on the same row (or just specify whole columns).
NOTE: When you use the lookup feature, you must make sure that
the one-column range specified for the "Use For Lookup" field
includes ALL the index data used for looking up. If there is data
above or below the range, KwikCount will not search it and if Allow
New is enabled, it could result in inadvertently creating incorrect
new entries and/or overwriting existing ones.
If Item Lookup is enabled, you will see the Allow New Items check
box. If you know that you have new items to add to your lookup
column, check this option to prevent KwikCount from displaying
"Item Not Found" on your Terminal when it cannot find an item
code already in your worksheet.
When you select the Item Lookup checkbox, the Check For
Duplicates button is enabled which is a feature that allows you to
check your lookup data for duplicate entries. To check your data for
duplicates, you must make sure that the range you haves selected
covers a single column and just the data you want to check. Do
not select the entire column and make sure the column contains
no blank cells.
If you do not use the Item Lookup option, all prompts will be
"Input" prompts and lookup features will be disabled.
Kommentare zu diesen Handbüchern