Creating a Complex Document - Requisition |
DataObject Name | : | Requisitions | |||||||||||||||||||||||||||
Table Name | : | requisition_master | |||||||||||||||||||||||||||
Group Name | : | General
Column Name | : | requisition_no - Int - Primary Key | requisition_date - Timestamp department - Varchar (20) remarks - Varchar (40) | Table Name | : | requisition_details | Group Name | : | General
| Column Name | : | requisition_no - Int - Primary Key | item_code - Varchar (20) - Primary Key requisition_qty - Double remarks - Varchar (40) | Table Name | : | requirement_schedule | Group Name | : | General
| Column Name | : | requisition_no - Int - Primary Key
item_code - Varchar (20) - Primary Key | required_qty - Doubel - Primary Key required_date - TimeStamp - Primary Key remarks - Varchar (40) |
Step 1:
Click new button, Enter Requisitions as DataObject Name.
Step 2:
Enter requisition_master as table name , set cardinality as OnetoOne Parent as none.
Step 3:
Enter General as Group Name
Step 4:
From generic tree node In objectrepository tree, drag and drop columns to dataobject tree.
Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.
Step 5:
Click Add table in the floating toolbar
Step 6:
Enter requisition_details as table name ,set cardinality as OnetoMany and parent as requisition_master.
Step 7:
Enter General as Group Name
Step 8:
Note : Primary key columns in parent table will be copied to the child table. ( requisition_no will be added to requisition_details automatically )
Select requisition_no , open property sheet and set value for Visible property as false.
(Note : During Database operation the key column values will be taken from Master table. If the column property visible is true then user has to enter value to save the record. )
Step 9:
Select requisition_details , Open Property sheet and set value for property UI to TabbedPane.
Step 10:
Expand ItemMaster tree node In objectrepository tree, drag and drop columns to dataobject tree. a. item_code - don't change any data, click Ok button.
Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.
Step 11 :
Click Add table in the floating toolbar
Step 12:
Enter requirement_schedule as table name , set cardinality as OnetoMany and Parent as requisition_details.
Step 13:
Enter General as Group Name
Step 14:
Note : Primary key columns in parent table will be copied to the child table. ( requisition_no and item_code will be added to requisition_schedule ). a. Select requisition_no , open property sheet and set value for Visible property as false.
(Note : During Database operation the key column values will be taken from Master table. )
Step 15:
Select requirement_schedule, Open Property sheet and set value for property UI to TabbedPane.
Step 16:
Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.
Step 17:
Click save button, check Table , Sql , checkbox along with defaults and Click Ok button.
Step 18:
Click Create button to create tables in Database.
Model Created Successfully.
Step 19:
Click FormFactory button in the ToolBar
Step 20:
Increase the Internal frame height ( Requisition Master )
Step 21:
Click objecttree button in toolbar or statusbar.
Step 22:
Select requisition_details and Click ShowObject button in Objecttree toolbar to design the table.
Step 23:
Click Swing Preview button in the Object Tree toolbar.
Step 24:
Close the Swing Preview and click HTML preview in object Tree toolbar.
Step 25:
Click Save button in the ToolBar.
Step 26 :
Click Compile button to compile the created class file.
Step 27 :
Execute the RRequisitions.bat file in \AppleseTutor\Src folder to Run the Class file.