J
JJP
Our database is structured along the lines of
OrderNumber, Product, QTY, Price
I want to be able to filter orders that have a specifc combination of Products
For example I might need to look up all the order that have a Generator and
any of three Waveform Monitors, i.e. TG700 and (WFMf6120 or WFM7020 or
WFM7120) but not order that have any other combination or do not have a TG700.
Can anyone help?
Thanks,
John
OrderNumber, Product, QTY, Price
I want to be able to filter orders that have a specifc combination of Products
For example I might need to look up all the order that have a Generator and
any of three Waveform Monitors, i.e. TG700 and (WFMf6120 or WFM7020 or
WFM7120) but not order that have any other combination or do not have a TG700.
Can anyone help?
Thanks,
John