Home » Developer & Programmer » Forms » Rows into Column. (Form 6i, 10g)
Rows into Column. [message #673064] Sun, 04 November 2018 06:43 Go to next message
shahzad-ul-hasan
Messages: 580
Registered: August 2002
Senior Member
Respcted,
Please view the tables below:
Table--Class:
Cid       Number(4) primary key
CName     Varchar2(30)

Table--Sub:
Cid       Number(4)  --Foreign key Class(CID)
Sno       Number(3)
Sub       Varchar2(4) --Subject of Class
The class table has 10 rows and sub has 30 rows: i want to select class and its subject shows as Column using master detail relationship.when i change class its automatically change its subject in columns.
please advised.
Re: Rows into Column. [message #673091 is a reply to message #673064] Mon, 05 November 2018 08:51 Go to previous message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
I don't understand what these mean:

"its subject shows as column"
"when i change class its automatically change its subject in columns"

Do you not know how to make a relation between two tables in Forms?
Previous Topic: Open OBIEE report from Oracle form 12c
Next Topic: Pre-insert not firing
Goto Forum:
  


Current Time: Wed May 12 03:32:44 CDT 2021