On 2008 May 16, at 7:21, Geoff Graham wrote:
On May 15, 2008, at 2:02 PM, Richard S. Russell wrote:
Calculated fields:
PO# & SKU -- linked to Truck Unit Tracker to establish load sizes
PO# left 4 bytes -- linked to Vendors table to get store name
and address
In his place, I would be tempted to make these auto-entered text
fields rather than calcs, if I was worried about performance. My
thinking is that once they are stored that would be one less piece
of overhead. I am curious what others think of that.
My understanding of calculation fields is that, once they are
computed, stored, and indexed, they're just as solid and quick to
access as manually entered data. If I'm wrong, this would be a swell
time to find out.