M
Mike, Controller
I'm attempting to take a table which shows pending orders by SKU and have the
data appear in a subform for a Form. The problem is the original table has a
single line for each order # which means I may have an SKU repeating several
times depending on the # of pending orders for that SKU. My subform will
only show the first order for an SKU and not all orders. How do I get the
data to show the SKU once, but display all of the pending orders for that SKU
in my subform?
data appear in a subform for a Form. The problem is the original table has a
single line for each order # which means I may have an SKU repeating several
times depending on the # of pending orders for that SKU. My subform will
only show the first order for an SKU and not all orders. How do I get the
data to show the SKU once, but display all of the pending orders for that SKU
in my subform?