Forms-2

Practice 11 - Create Data Blocks with Relationships

Creating Master Block

================

1.   Right click on Object Navigator | Forms | Data Blocks then select

Data Block Wizard.

2.   At Data Block Wizard - select

      Table or View

Then click Next

3.   Enter DEPT in the edit box of Table or view.

Then click Refresh

Click  select all to database items

Then click Next (Enforce Data Integrity, Content Canvas, Single Record, Form Style, No Scrollbar)

4.       Complete creating the Dept Block

5.      Detail Block Creation

6.      Create a new data block

7.      Select the Table (ex. EMP), enforce data integrity

8.      Select

9.   Click Create Relationship (Auto create relatioship should be checked)

Click OK for the next dialog box.

10. Use the same canvas used by Master block, Should be Multi-Record (in most cases), Style should be Tabular(to display multiple records), Scrollbar should be displayed)

11. Use the default Width and Height

Then click Next

12. Select

       Form

Then click Next

13. Frame Title: DEPARTMENT-EMPLOYEE DETAILS

Records Displayed: 1

Distance Between Records: 0

Then click Next

Then click Finish

14. Compile and Run Form