<< Click to Display Table of Contents >> Navigation:  HearAid On-Line Help > Work Areas > Administrator > Column Attributes

HearAid offers the ability to

•Alias column names i.e. give columns a different name to make them more useful or appropriate

•Make some columns MANDATORY so that users must enter data for that column or field before the data can be saved

•Hide columns that are never used

In order to do these things, the user needs to

1.Be logged in as SYSDBA

2.Select Tools|Column Attributes in the Program Navigator

In the example above, the CLIENTS table has column names PHONE_1 and PHONE_2, but PHONE_1 has been given the alias Home and when the Client Details work area is opened the row for Phone #1 has been relabelled Home

The screenshot also demonstrates how mandatory fields (which have the DB_REQUIRED or MANDATORY boxes ticked) are highlighted if the Highlight Mandatory Fields box is ticked in Tools|Options|General

Fields that are neither DB_REQUIRED or MANDATORY can also be hidden, by un-ticking the VISIBLE box