I'm working on a report that has that has part #'s and other associated data with the part #. Some of the parts#'s are also associated with another part and we call that the master part. For example:
Part 123 is the master part. Quantity to produce is entered as zero.
Part 124 is a member part of Part 123. Quantity to produce is 1000.
Part 125 is a member part of Part 123. Quantity to produce is 2000.
Part #123 does not have an order quantity. But part # 124 and 125 do. I'm trying to add the quantities of part 124 and 125 together and reference back to Part 123, but declaring a variable. We can't enter a quantity for 123. What declared variable do I use- while printing records or while reading records. I would like the report to show "Part 123 Quantity to produce = 3000".
In my table, I have the master part # set up as a field for the member parts. I can suppress the quantity of 124 and 125 by looking at my table and if the master part # field is not null.