I am have two tables.

In table 1, I have:

• a (non-primary) field with 3 single select options (let’s call it field A)


• a field linked to records in table 2 (field B)

In table 2 , I have:

• the table’s primary field, from field B in table 1 (field C)


• a field that counts the number of linked records (field D)

I would like to filter the field that counts the number of linked records (field C) in table 2 so it only counts for one of the 3 single select field (field A) in table 1.

I looked around the forum, and some answers seemed to deal with the same issue but I could not get any to work for my case.