Home » Categories » Solutions by Business Process » System Features |
Desktop Database Tools - Additional F4-Select Options |
Article Number: 66 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 6:29 PM
|
Datafile Software Desktop Database Tools - Additional F4-Select Options Earlier releases introduced the facility to sort by default the records displayed from an <F4-Select> search based on one of the columns displayed, whilst this release adds the facility to default to a set search item. From Release 6.5 the Desktop Database options ‘Databases on Desktop’, ‘Forms on Desktop’ and the (Premier only) ‘Database Plus on Desktop’ configuration options have been updated to include both of these facilities. Installation Desktop Database Configuration The <F4-Select> display for the Desktop Database
options are configured through the Desktop Tool options. To update the tools select Database Systems from the main menu
followed by Datafiler Database Utilities and then Desktop Tools Definition. Select the required list option from the
menus Databases on Desktop Definition,Forms on Desktop Definition and Database Plus Definition before
selecting the option database definition from the list. Confirm any authority settings for the
database before selecting the UPDATE button and select the Screen Action / Options parameter screen. The new F4-Select configuration options are
available on the second screen of parameters. Auto-Sort Column – select which of the data items above the search results within <F4> are to be sorted in. The column number corresponds to the entry numbers 1-10.Setting this option overrides the LIFO sequence parameter available on this screen. Auto-Sort Descending– if a sort item is set then setting this parameter processes the sort in descending rather than ascending order. F4-Focus – when you press F4-Select you can search based on the prime-index of the database, any set secondary indexes and (if Premier) any set extra selection items. Set the focus item to ‘1’ to default the search to the prime-index, to ‘2’ or ‘3’ for any set secondary indexes, and ‘4’ through to ‘9’ for any of the extra selection items. Pressing the <F7-Option> key on this item allows you to view the set secondary indexes and extra selection items for the current database. |
Attachments
![]() There are no attachments for this article.
|
Landing Pages - Sorting and Grouping on Table Items
Viewed 151 times since Thu, Oct 17, 2024
Warehouse Tablet - Sales Order Pick Note Image Capture
Viewed 189 times since Thu, Oct 24, 2024
Sales / Purchase – Transactions to be Displayed
Viewed 1131 times since Tue, Jun 12, 2012
SMB2, SMB3 and Opportunistic Locking
Viewed 24009 times since Tue, Apr 8, 2014
Landing Pages - Copy Configuration between Users
Viewed 927 times since Thu, Jun 18, 2020
Application Memos – Warning or Note
Viewed 1093 times since Wed, Jun 13, 2012
Ledger Enquiry - Increased No of Stock Location Pick Items
Viewed 127 times since Thu, Oct 17, 2024
Ledger Enquiry – Improved Scans Option
Viewed 1105 times since Wed, Jun 13, 2012
Output to Pivot Tables - Accept and Save Options
Viewed 4617 times since Tue, Jun 12, 2012
General System Options - D02.DFD – Include Sales and Purchase Order Authorisation Limits
Viewed 47 times since Thu, Oct 17, 2024
|