Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 11 to 13 of 13 total

Calculated fields or SQL

Mon, Jan 26 2009 12:08 PM	Permanent Link
David Darlison	Fernando Dias wrote: >If the "Parts" table is small, you can also use a lookup field to get parts.price, with "LookupCache" set to true. I have a lookup field in the Items table for parts.price but LookupCache is false. There are about 2000 records in the parts table. So is it better to multiply this lookup field by qty using OnCalcFields rather than SQL? David
Mon, Jan 26 2009 12:50 PM	Permanent Link
Fernando Dias Team Elevate	David, But parts.price is not being cached (or even changed), so I don't see any problem here using one method or the other. -- Fernando Dias [Team Elevate]
Mon, Jan 26 2009 1:05 PM	Permanent Link
David Darlison	Fernando Dias wrote: >But parts.price is not being cached (or even changed), so I don't see any problem here using one method or the other. Ok, thanks.

« Previous Page	Page 2 of 2
Jump to Page: 1 2