I've got 6 related tables. I would like to display information from all these tables on one page.
===

Table 1 : Company Information
Table 2 : Financial
Table 3 : Media
Table 4 : SWOT Analysis
Table 5 : Events
Table 6 : Interests

I will like to create **one page** to display all these tables in Oracle Application Express.

However,I do not want all the rows of data to be displayed. I will only like to see related data when a specific company is selected.

For example, 
select Ansa Mcal (then all the information from the tables relating to ANSA Mcal will display)
select Nedcom (then all the information from the tables relating to Nedcom will display).

Thank you for your help.
Please be as detailed as possible as I am a beginner in APEX. 

