Creating main data tables

In this section, we will create a main table, similar to the customer table. The steps are similar to the vehicle group, and we will abbreviate some of the steps we have already done. The pattern described in this recipe can be applied to any main table using your own data types.

The table in this example will be to store vehicle details. The table design will be as follows:

Field	Type	Size	EDT (: indicates extends)
VehicleId	String	20	ConWHSVehicleId : Num
VehicleGroupId	String	10	ConWHSVehicleGroupId
RegNum	String	10	ConWHSVehRegNum
AcquiredDate	Date		ConWHSAcquiredDate : TransDate

Getting ready

In order to follow these steps, the elements created earlier in this chapter must be created.

How to do it...

To create the vehicle table, follow these steps:

1. Create the ConWHSVehicleId string EDT with the following properties:

Property	Value
Name	ConWHSVehicleId
Extends	Num
Label	Vehicle Id
Help Text	The vehicle id

2. Create the ConWHSVehRegNum string EDT with the following properties:

Property	Value
Name	ConWHSVehRegNum...