Also,it would be ideal for me to make this happen from the item table and not the transaction table.