Master-Detail-Detail

[mhsabado_(Guest)]

Hi,____Is there a way I can make a Master->Detail->Detail report?____I have a master table that is linked to more than 1 table with one-to-many scanning. The scenario would be like my master table (invoice header) is link to inventory table and GL entries table. Is this doable or there^s some workaround maybe?______Thanks,__Mario

[kfleming]

What do you want the layout of the report to look like?____Kathleen__R&R Support

[mhsabado_(Guest)]

Hi Kathleen,____I want to have two bodies with different headers like the following:____Page Header-> Invoice#, Particulars, TrDate ____Group1 Header-> Item Code Description Unit Qty__Body -> 99999999 xxxxxxxxxxxxx xxx 9__Group1 Fooder -> Total 99____Group2 Header -> GL_Code Acct_Name Debit Credit__Body -> 99999 xxxxxxxxx 9999 999999__Group2 Fooder -> Total 9999 999999____Page Footer -> some notes________>What do you want the layout of the report to look like? __>__>Kathleen __>R&R Support __