AnsweredAssumed Answered

Lookup summary field in related table not returning correct count

Question asked by cmcleod on Jan 12, 2019
Latest reply on Jan 12, 2019 by onefish

Hey

 

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 ).

 

Thanks

Outcomes