how to do a report with that includes sub records
I have a product table and a related sub product table. I want to be able to run a report that lists the products and where a product has a sub product/s list those below the product. Where a product has more that one sub product the report only displays the first subproduct.
I've also tried using a portal in the report which works but that means I have to set the portal size for the maximum number of sub products and this looks very messy for products that have none or one subproduct
Any help greatly appreciated