taras
Posts: 11
|
Posted: 07/13/2004, 1:51 AM |
|
Does anyone know what is proper and better way to do such thing?
Lets there is 2 tables, "A" and "B".
Table "A" hold main data and table "B" hold records that can act as additional information to some record in table "A"
Each record of table "A" can correspond to few records inside table "B".
How I can build page if I want to list all corresponded records from table "B" after each record of table "A"?
So it will looks like this:
A-record 1
B-record 3
B-record 7
B-record 8
A-record 2
B-record 17
B-record 10
B-record 13
...
Thank you!
|
|
|
johny_f
Posts: 23
|
Posted: 07/13/2004, 2:18 AM |
|
If it is simple DB structure, just define "join table" in the grid (left-join or inner dependently on your db)
You will get data (grid) like
A-record 1 -- B-record 3
A-record 1 -- B-record 7
A-record 1 -- B-record 8
A-record 2 -- B-record 17
A-record 2 -- B-record 10
A-record 2 -- B-record 13
etc.
than read article in help:
Examples and Techniques/Simple reporting/
Simple Report with Simple Grouping
---
Hope this will help,
For more complicated structure I use custom coding
_________________
Johny_f |
|
|
taras
Posts: 11
|
Posted: 07/13/2004, 3:45 AM |
|
THanks joghny_f!
I will try
|
|
|
|