
3) All other fields (Date, FuelCost, FuelQuantity, Odometer, and
PaymentType):
• Type the next field name in the Field Name column.
• Select the Field Type for each field.
– For Date use Date[DATE]. (Press the D key to select it.)
– PaymentType uses Text [VARCHAR], the default setting.
– All other fields use Number [NUMERIC]. (Press the N key
once to select it.)
• FuelCost, FuelQuantity, and Odometer need changes in the
Field Properties section (Figure 187).
– FuelQuantity: Change Length to 6 and Decimal places to 3.
(Many fuel pumps measure fuel to thousands of a gallon in
the USA where I live.)
– Odometer: Change the Length to 10 and the Decimal
places to 1.
– FuelCost: Change the Length to 5 and Decimal places to 2.
Click the Format example button (Figure ). This opens the
Field Format window (Figure 188). Use Currency as the
Category and your currency as the Format. My currency
has two decimal places. Use what is appropriate for yours.
Figure 187: Changing field properties
Chapter 8 Getting Started with Base 261
Comentarios a estos manuales