I've read other posts but none are working for me. I'm building a simple inventory and want my quantity field to count how many records contain the same model number of the record being browsed. We may have 10 of the same item, but each needs a different record because of different serial numbers.

So I tried the count(solution::model) and that is not updating the quantity like I'm expecting it to.

Create a self join relationship based on Model, say Solution2.

Create a summary field in Solution, say Nb_items = Count of (Solution2:Model).

That's it.

I attach a demo.

Items.fp7.zip