Home » Developer & Programmer » Forms » SHOWING DISTINCT COLUMN
SHOWING DISTINCT COLUMN [message #220280] Tue, 20 February 2007 00:41 Go to next message
ataufique
Messages: 79
Registered: November 2006
Member
I have a form in which i have a non distinct column call code.
i.e say code='A' has six rows(12 other columns)...

Now in my form i need show distinct records for code(1 row) and below that six rows(12 other columns)...

Help needed is how can i show distinct code and below 6 rows..

Re: SHOWING DISTINCT COLUMN [message #220490 is a reply to message #220280] Tue, 20 February 2007 21:36 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
Anyone who can support ..
Re: SHOWING DISTINCT COLUMN [message #220534 is a reply to message #220490] Wed, 21 February 2007 02:28 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using master-detail, perhaps? Master block would select DISTINCT code values, while detail would show the rest (those 12 records you mentioned).
Previous Topic: About version of Oracle dev suite
Next Topic: who search by 2 values in forms
Goto Forum:
  


Current Time: Wed Feb 12 22:10:21 CST 2025