Is this possible?

[MiltyKiss]

So I've been trying to figure this out and it's not coming to me.

I have a fmp5 (I'm using FileMaker Pro 5) file that will contain a product name, two types of serial numbers, and the status of the product. On the front page, I would like it to display how many of each product we have with each status.

Example:

Product Names = Fruit

The front page would say...

Apples (Normal): 11

Apples (Eaten) 1

Grapes (Normal): 12

What would be the easiest way to do this? >_<

[Tim W]

Hi & welcome to the forum,

There are three ways that I can think of.

1. use an unstored global calculation field to total the quantity of each type. The down-side to this method is that for a large data set, you will see a speed drop, since the calculation must recalculate each time the field is viewed.

2. use a stored regular field and update the value each time the quantity is altered. The down-side to this method is that it is very intensive.

3. Maybe a third method could be a button, triggering a script to total the records and update the current quantity totals on demand with a second field to store the date of the last update.

HTH

Tim

[MiltyKiss]

2. use a stored regular field and update the value each time the quantity is altered. The down-side to this method is that it is very intensive.

Hmm... This sounds like the best solution out of the three, but how would I go about starting that? :)

[Tim W]

Hi Milty,

Well I set out to build you a sample, however a truly dynamic view (like what would be presented by a sub-summary report) is very difficult. Is the list of status hard coded (firmly defined), all fruits will have all of the same status. i.e. Natural, eaten, sold, ruined.....etc.

The idea I have is does an apple change from natural to say eaten or do you simply have ## of natural and ## of eaten?

Anyway, here is a sample file. Maybe this will be of help.

Tim

PRODUCTS.zip