I have a database that has two files. The relationship is one to many. The sales analogy works good here. Assume that the first file has the name of the customer in it, and a key field to link it (by customer) to the second file (nothing else is necessary for the example). The second file has the orders with fields that include the amount of the purchase, and the item purchased, and a key field that links it to the first file.
How can I get a list of all the customers that have never purchased a hammer? The problem I am having is that the record selection formula compares each purchase. Therefore, when I write
not(purchase.item = hammer)
I get customers that purchased anything other than a hammer, even if one of their purchases was a hammer. I need a way to say "only show me the customers where NONE of the purchases are hammers."
There just has to be a way to use the selection formula on the second file as a whole.
This has to be easy to do, but I am not a professional programmer and I have spent hours trying to figure this out. Any help is appreciated.
How can I get a list of all the customers that have never purchased a hammer? The problem I am having is that the record selection formula compares each purchase. Therefore, when I write
not(purchase.item = hammer)
I get customers that purchased anything other than a hammer, even if one of their purchases was a hammer. I need a way to say "only show me the customers where NONE of the purchases are hammers."
There just has to be a way to use the selection formula on the second file as a whole.
This has to be easy to do, but I am not a professional programmer and I have spent hours trying to figure this out. Any help is appreciated.