Hi Gert, > "Select catno, catdescription, itemno, itemdescription from stockmaster", > where there is 1 to many relation between catno and itemno. > > What want to do is put a (group) header with catno and catdescription, > followed by multiple lines with itemno, itemdescription.
Ah, okay. Well, this should also be possible with the hidden controls in the form navigator, as mentioned in my previous mail. I have to admit that I did not dive into the details of the system used with these fields, I just know that they should contain all necessary information ... Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
