Sort by popularity?

[FruitFul]

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?

[Slobey]

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)