I’m hoping Pan X has a slick way to do this. Maybe Pan 6 does this as well, but I’m drawing a blank on how to proceed.
I have an Invoice database with 14 line items per record. Often I have occasion to search a date range of Invoices looking for the presence of a particular product, and it could appear on any line item. It’s easy enough to retrieve the invoices in a date range, and lineitemarrays make it very efficient. I can construct a list or array of the Invoice numbers that contain this item as I process the records, but I’m stuck trying to build a Select command that would then select just those invoices for view. I can think of 2 different ways to do this, but neither is the least bit elegant and I wonder if there is a better way.
Select «Invoice» = list_item_1 or «Invoice» = list_item_2 or ...
(this could be a long list)
Select «Invoice» = list_item_1 SelectAdditional «Invoice» = list_item_2 ...
The list_item could be an array or any other construct that I can build as I parse the original date range data. Is there a way I can use this array or another form of list in a one-step Select statement, something like:
Select «Invoice» = list_item_array
The «Invoice» field is numeric.