Board index » delphi » Showing all master-detail records on one grid

Showing all master-detail records on one grid

hi there,

Is it possible to show all master-detail records on one grid in the
following format.

Column 1 from master table                     Column 2 from detail table
    ------------------------------------------------------------------------
------
    Col 1    |                                         Col 2
|
    --------|---------------------------------------------------------------
-------|
    Rec1    |      Rec1    Rec2    Rec3    Rec4    Rec5      Rec6    Rec7
Rec8    |
    --------|---------------------------------------------------------------
-------|
    Rec2    |      Rec1    Rec2    Rec3    Rec4    Rec5
|
    --------|---------------------------------------------------------------
-------|
    Rec3    |      Rec1    Rec2    Rec3
|
    --------|---------------------------------------------------------------
-------|
    Rec4    |      Rec1    Rec2    Rec3    Rec4    Rec5      Rec6    Rec7
|
    ------------------------------------------------------------------------
-------

Record could be more than one field (e.g. Instr ID,  Name) both for master
and detail. Scroll Bars will appear in the individual cell if there are more
records in any cell in column 2. This is sort of a grid embedded in the 2nd
column of the main grid. Any help/suggestions would be greatly appreciated.

Thanks in advance.

Swarn

 

Re:Showing all master-detail records on one grid


Sorry! the columns in the original message got messed up. Columns are like
this

 Column 1 from master table                     Column 2 from detail table
     ----------------------------------------------------------------------
     Col 1    |                                         Col 2
|
     --------|------------------------------------------------------------ |
     Rec1    |      Rec1    Rec2    Rec3    Rec4    Rec5      Rec6
|
     --------|------------------------------------------------------------ |
     Rec2    |      Rec1    Rec2    Rec3    Rec4    Rec5
|
     --------|------------------------------------------------------------ |
     Rec3    |      Rec1    Rec2    Rec3
|
     --------|------------------------------------------------------------ |
     Rec4    |      Rec1    Rec2    Rec3    Rec4    Rec5      Rec6    Rec7
|
     ---------------------------------------------------------------------

Thanks again

 Swarn

Re:Showing all master-detail records on one grid


Quote
Swarn wrote in message <8h3fqf$d...@bornews.borland.com>...

>Is it possible to show all master-detail records on one grid in the
>following format.

Treeviews are perfect for this. There are several 3rd party data-aware
treeviews available that will build such a display for you, just
search around the various Delphi sites like Torry's.

--
Wayne Niddery - WinWright Consulting
RADBooks - http://members.home.net/wniddery/
You have a Right to Free Speech, but not the right to make me listen,
nor to use my property as a soapbox.

Other Threads