Tables and joins

A relational database table stores the data that an application uses in columns and rows. Each column is a Data item and each row is a record. We can create one or more tables for use in an application. To create a table, we can select data items (the data items must already exist in the data dictionary).

For creating a table in OMW Projects, select the objects and click Add

Select the option Table in the screen

Click Ok

Enter Object name, Description, Product Code, Product System Code and Object Use and Click Ok.

For designing the table click Design Tools, then click Start Table Design Aid in the screen

Give data item in the Alias field, already available in data dictionary, then drag and drop in to the
Column. For setting the primary key, add the particular data item in indices and save

Click Ok

Click Table operation and Click Generate table in the screen

For generating the index, click Generate Indexes in the screen

Click Ok