BLOMASKY I have a need to find all items that a customer has purchased. each one only once no matter how many order lines there are for the item? In SQL its really easy, is there a trick to do that in Aware that I am missing? Thanks Bruce
weblike Hi Bruce, Here is a demo posted by tford, very powerful: https://forum.awareim.com/d/6633> Hope this helps, If you need further tips, let me know. cheers,
tford Hi George, Do you happen to still have the demo BSV that is referred to in that link. I didn't retain it after posting to the forums. Silly me.
weblike tford wroteHi George, Do you happen to still have the demo BSV that is referred to in that link. I didn't retain it after posting to the forums. Silly me. I will search for it and if I have it I will share it again. Cheers
weblike Hi, Here is the bsv file: https://www.dropbox.com/s/5uxjg414f74gtfe/Filtering_Demo_1_20_2014_5_pt_8.bsv?dl=0 cheers,
