Data Entry in CAPS
Anyone have any bright ideas of making data entry into one field in the main table - as upper case ?
You can acheive this in two ways.
1. Using Import Manager: After mapping your required source field with your destination field. Right click on this field --> Set Value Conversion filter -->Change Case --> UPPER CASE
This results in your source field values into Converted Value in Upper case.
2. Using Data Manager: Create an Assignment and Put Table Field = Field of your main table for which you want Data Entry in Caps. In Assignment Expression write : UPPER(Field Name).
Hope it will Help you,