J
JJP
Our database is not relational. Each order number is repeated for each and
every line item so if an order has ten different products there are at least
10 rows. Sometimes I need to find order that contain specific combinations of
products. For example I might need to find order that contain products B and
(F or Y). So far I have done this by creating a query that looks for orders
with product B, then a Querry that looks for orders with F or Y, then a query
that links the two previous queries and finally another query that lets me
see the entire value of the orders that contained B and (F or Y) plus that
value of anyother products in that order.
It does not work very well and is cumbersome. Is there a better way?
Thanks,
John
every line item so if an order has ten different products there are at least
10 rows. Sometimes I need to find order that contain specific combinations of
products. For example I might need to find order that contain products B and
(F or Y). So far I have done this by creating a query that looks for orders
with product B, then a Querry that looks for orders with F or Y, then a query
that links the two previous queries and finally another query that lets me
see the entire value of the orders that contained B and (F or Y) plus that
value of anyother products in that order.
It does not work very well and is cumbersome. Is there a better way?
Thanks,
John