Table A and B are related. In Table B, I would like to see a count of records related from Table A, based on  criteria in an unstored calculation field, such as TableA::Status ("Sold", "Available", etc.). In other words, in Table B I would see a count of sold records (related from Table A), available records (related from Table A), etc.

 

Available: 6

Sold: 5

Total: 11

 

The Total is easy: for example Count (TableA::Record ID) However, I can't build a relationship based on an unstored calculation, such as TableA::Status - so what do I do??

 

If anyhow possible, I would like to avoid calculation fields in Table A, because there's a lot of records. If I have to add a couple of calculation fields in Table B, that's ok.

 

A combination of List, FilterValues, and ValueCount should do the trick.

A combination of List, FilterValues, and ValueCount should do the trick.

 

 

Thank you! Sometimes I feel so confined in my own mind... lol

 

 

If anybody else has a similar challenge, here's the solution Fitch suggested (or my interpretation of it) to compare the number of "Available" records with the total number of records related:

 

TableB::Availability [ValueCount (FilterValues (List (TableA::Status); "Available")) & " / " & Count (TableA::RecordID)]  Result must be Number

 

The result looks like this:  3 / 5

Result must be Number

 

The result looks like this:  3 / 5

 

No, the result type in your example is Text.