Counting related records

[Sxeptomaniac]

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

[-Queue-]

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.

[Sxeptomaniac]

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