A tale of two tables.....

Table #1 has a number of fields in it, including one called "Software Link" (number field) which is relevant to this question.

Table #2 has two fields in it, one called "Software Connection" (number field) and the other called "Software Count" (calculation field).

Table #1 has a few hundred records. The "Software Link" field on each record is populated by a number with up to three digits (and it's not unreasonable to think that it'll go up to four or maybe even five in the future).

What I need is a calculation for the "Software Count" field that will tell me how many times the value in "Software Connection" appears in "Software Link".

I tried doing a patterncount but it didn't work. When "Software Connection" was set to 5, "Software Count" would count records such as 5, 15, 52, etc. That's not what I want.

I *know* this is simple but I'll be damned if I can't figure it out.

I could be wrong, but this seems simple. If you had a relationship between the two tables, based on Software Connection to Software Link, you could just count the relationship:

Count ( relationship::Software Link) // or any field that always has data

A relationship is always an "exact" match for (any line of) the key. The calculation would be an unstored field.

There's no direct relationship between the two tables; there's one table between them.

Happily, however, I found a formula that works.

If ( (Software Connection = Software Link) ; Count ( Software Link) ; "" )

Works like a charm.

There's no direct relationship between the two tables; there's one table between them.

Happily, however, I found a formula that works. :

If ( (Software Connection = Software Link) ; Count ( Software Link) ; "" )

Works like a charm.

Case is better, you do not need the final no-match term.

case (

Software Connection = Software Link ;

Count ( Software Link)

)