I have been learning a lot from these forums, and wondered if there was an answer to one of my earliest issues I ran into.

I have a solution designed to track a vehicle's information and the information of any tickets written for that vehicle. We can then keep track of how many tickets each vehicle has, and how many of those are unpaid. I currently track this with calculation fields using the Count() function via relationship.

I know that calculations using related fields are a bit slow. Is there something I am missing that would work as well? I've experimented with Ray's Calc, but it doesn't seem appropriate to this situation.

I figured someone else might have a better idea.

Matt

The only thing I know of that would be faster than a Count calculation would be a scripted Count, regularly setting a field with the new count whenever a change is made (or record added) that requires an update. Then it will not need to be calculated every time a record displays the field or requires the calculation for another field to be displayed, only when the count is changed.

Well, it seems my options are pretty limited. Thanks for the info.