October 4, 200520 yr Greetings, I would like to be able to have my value list sort by the most popular items. I have a solution for my photography studio, and as we make new orders for clients, it is a pain to sift through all of the products for every single line item. I do currently have it set up so that within the product area, I can see within each individual product which invoices have had that particular item on it. I am wondering if there is someway to 'count' these occasions. So basically any given product would have a number cooresponding to it that is based on total sales. And then to somehow have my value list 'sort' based on this number?
October 4, 200520 yr When you say counting these occasions, do you mean the total quantity of that product that has been sold? If yes, then how do you have the tables related?Do you have a standard 3 table set up (product, invoice and invoice line items)
Create an account or sign in to comment