I am trying to come up with a method/approach to solve the following and would welcome any suggestions!

I have a table that stores all of the dealers that I distribute products to. To get lower pricing dealers can put certain products on their display floor in their retail store. I track what they have on the floor in a related table that I show in a portal on the dealer layout.

My question is that I want to run a report or have a screen that shows which dealers are meeting my dealer display requirements and I am not sure how to calc this. For example, a dealer may need to have three of one category of item to get special pricing and I need to have some logic to check the related table to see if they have three of this category on display and then report yes or no for whether they meet the display requirement for that category.

Thanks.

Well it seems to be in the neighbourhood of this:

http://previews.filemakermagazine.com/videos/585/InterfaceSummaries_full.mov

--sd