|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
List query results in groups
I'm running a query to list manufacturers and product names, order by mfg ASC, productname ASC. Currently I have my display as such...
MFG 1 product 1 MFG 1 product 2 MFG 1 product 3 MFG 2 product 1 MFG 2 product 2 What i would like is this... MFG 1 product 1 product 2 product 3 MFG 2 product 1 product 2 Any suggestions? |
|
#2
|
|||
|
|||
|
RE: List query results in groups
how about the logic something like...
select all from mfg foreach mfg record print mfg record select all from items where mfg_mfgid = item_mfgid foreach item record print item record endforeach endforeach Pryce |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > List query results in groups |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|