List of Values
Using the List of Values simplifies data entry. There are multiple ways to search through a
List of Values.
·
Type the first character(s)
of a value to reduce the list.
·
Enter search criteria; then
click [Find].
·
Scroll through the list and
select the value.
Format
·
Date
format: DD-MON-YYYY.
Notations
·
(N) = Navigator
·
(M) = Menu
·
(T) = Tab
·
(B) = Button
·
(I)= Icon
·
(H) = Hyperlink
·
(ST) = Sub Tab
·
(Drop Down) = DropDown List
Example:
(N) People > Enter and Maintain
(M) View > Query By Example > Enter
Short Cut Keys
|
<F11>
|
Enter Query
|
|
<Ctrl><F11>
|
Execute Query (Refresh screen)
|
|
<F4>
|
Cancel Query
|
|
<F12>
|
Count Query
|
|
<Ctrl><S>
|
Save (Commit)
|
|
<Ctrl><L>
|
List of Values
|
|
<Shift><F5>
|
Duplicate Field from Above
|
|
<Shift><F6>
|
Duplicate Record from Above
|
|
<F5>
|
Clear Field
|
|
<F6>
|
Clear Record
|
|
<F7>
|
Clear Block
|
|
<F8>
|
Clear Form
|
|
<Ctrl><Up>
|
Delete Record
|
|
<Ctrl><Down>
|
Insert Record
|
|
<Ctrl><U>
|
Update Record
|
|
<Shift><Ctrl><E>
|
Display Error
|
|
<Ctrl><E>
|
Edit
|
|
<Shift><Tab>
|
Go to Previous Field
|
|
<Tab>
|
Go
to Next Field
|
Query vs Find
|
Query Mode
|
|
Find Mode
|
|
Menu
bar, <F11>
|
|
Menu
bar, Toolbar
|
|
Existing
Window
|
|
Find
Window
|
|
Wildcards
|
|
List
of Values
|
|
Query
Count
|
|
No
Find Count
|
Query Mode –
Searches the database
·
Set search parameters for
the query in the existing window to narrow the search.
·
When using wildcards, use
any query operators to narrow the search.
·
Check to see how many
records match the criteria before retrieving the matching data.
Find Mode –
Searches List of Values
·
Set search parameters in the
Find window.
·
A List of Values is
available for many fields in Find mode.
Wild Card –
Two Wild Cards
·
Use a percent symbol (%) at
the beginning, end, or beginning and end of a word. The % character represents
a number of character.
·
Use an underscore (_) at the
beginning, end, or beginning and end of a word. The underscore represents a
single character.
Field Colors
|
Field Color
|
Description
|
|
White
|
Allow data entry
|
|
White with green text
|
Indicate drill-down capability
|
|
Yellow (*)
|
Require Data entry
|
|
Blue with green text
|
Indicate drill-down capability
|
|
Blue with black text
|
Are display only
|
|
Blue
|
Indicate fields to use in Query Enter
mode
|
No comments:
Post a Comment