Im trying to remove unstored calcs from my solution and have run a across an issue I could use some help with.
Ive created a lookup field and table A. to lookup based on TableA, the value for TableB::summary_id_count
the problem is the lookup is returning the entire record count, as if its disregarding the TO relationship which clearly.
if i add the field summary_id_count to my TableA Layout it displays only the count of related ID's
What gives? suggestions?
PS. Alternatively i just tried to use the fields auto-enter calculation, no success, I wasnt able to even get it to display a value when using this formula Count ( TableB::id ).