I have been tasked with what I hope I explain in a way that is understandable.
In this data pull, the user will have an option to limit the number of Orders to pull for a given Customer. We will assume 3 orders, but they may have multiple lines per order, we need to include those lines.
- Read table record, search array, if customer found, check if order exists and if the order count is 3 or less write array if order limit reached and in the array for customer bypass until new customer is read.
- Need to keep count of orders processed are within the order limit of 3.
- Repeat for records in the table and search array.
In the attached file, I have a sample of the Table data that will be read and written to the array.
I also have the code I would tweak to hopefully make this happen.
Thank you in advance,
FrankCLT