Home » Categories » Solutions by Business Process » System Features

T-Table Description as Data Item

Datafile Software

T-Table Description as Data Item

When showing table items on screen the system shows the value followed by the text description associated with it. When showing on reports / documents then generally only the value is shown, similarly when outputting to a CSV- file only the value is output.

A new feature allows for the creation of a sub-item based on the table value but the sub-item will contain the table description and not the value. This can be displayed in screens, reports, and documents plus be used in lists and CSV output.

Installation

Restructure a Database

When creating a sub-item you can now base this on a T-Table item.

When defining a sub-item you are asked for three parameters:

qItem – data item this is to be based upon

qStart – would usually be ‘1’ when working on table items this is the character position at which the sub-item is to start.

qSize – maximum of ‘32’ for table items (if start at position 1) otherwise remaining balance of field or less as required.

Custom Fields
  • Release ID: 5.9
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Salesperson Access Filter for Sales Accounts and Sales Orders
Viewed 2755 times since Fri, Oct 26, 2012
Extra Secondary Indexes
Viewed 1557 times since Wed, Sep 21, 2016
Pick Lists – Saved Selection Criteria
Viewed 624 times since Thu, Jun 18, 2020
Application Pick Lists - Apply Colour Highlighting Rules
Viewed 1820 times since Wed, Sep 21, 2016
F8-Zoom - Allow Other Searches and Enquiries
Viewed 4126 times since Fri, Jun 8, 2012
Additional F4-Select Options
Viewed 3130 times since Wed, Jun 13, 2012
Order Enquiry - Allow Label Print from Order Details
Viewed 1956 times since Mon, Jun 11, 2012
Select Enquiry
Viewed 2032 times since Tue, Jun 12, 2012
Log User-Id / Date / Time Database Record Updated
Viewed 3401 times since Fri, Oct 26, 2012
Ledger Enquiry - Nominal Enquiry Transaction Panel
Viewed 149 times since Thu, Oct 17, 2024