I would like to attempt a sup report in my 7.6 database.
We create packing lists for the product we ship out. Here are the details: The present report is based on a temp view with five tables. These tables are Orderheader, Orderrows, Prodpart, partinfo, & Material The Orderrows table has the model# field, which is a break point. This table also has a field Sortone that tells what product line the model belongs to. Here are the breaks: Detail section Partnum Break 0 Control# (some would call this an Order number) Break 1 Model# What I want to accomplish is this: If the sortone field = 'BL' then I want the sub report to print an extra detail packing list for certain kits based in a table ASSY_PART. The ASSY_PART table has a field Assembly# that has the same data as the Partnum field in the Partinfo table (part of the view above). In essence I would have IF sortone = 'BL' then based on the model# and partnum the sub report prints WHERE the Assembly# = Partnum. James Belisle
