Count one value based on another value - Q2...

[caman]

Hello.

Another question;

I do have, in my db, a single table.

I have the fields:

"ID"

"Productnumber"

"Location"

"In_Stock"

"Total_In_Stock"

My question is;

I have several productnumbers, both with and without letters/ numbers, but they are not unique.

Each Productnumber is given a location.

Each Productnumber with Location is given a number in stock, from 0 to 2000.

Each location is not unique to that productnumber.

But, I might have the same productnumber several times, but with different locations, and different number in stock.

I need the field "Total_In_Stock" to count the total number in stock for each Productnumber.

I.E. I have:

PO# "920-580" on Location "H1" with 2 in stock, and on location "291504" with 7 in stock.

The "Total_In_Stock" would be 9.

PO# "MayOS" is located only on Location "VM2" with 4 in stock.

The "Total_In_Stock" would be 4.

You get my drift?

Regards

Christian

[Søren Dyhr]

Watch this:

--sd

[caman]

Hello.

Thank you for that informative video.

But...

I might be a bit sleepy, but as far as I understood, this only works when creating layouts for previewing, and not in standard browse mode...

If there is something I've missed, please explain.

Christian

[Søren Dyhr]

It's becasue the video originates from ver. 8.5 or 9 where the new feature Dynamic reporting still was unknown to the masses:

http://fmdl.filemaker.com/MISC/fmp10/dynamic_reports_640x400.mov

--sd