Event 1 Office Connector Web HelpOnline Help

TSLookup Function
Contents Index

The TSLookup function returns a value from a specific field on a specific record in a Timberline Office database.

Syntax

TSLookup( table name , field name , [key1 ] , [ ... keyn ] )

The TSLookup function syntax has these parts:
ArgumentDescription
table nameRequired. This argument identifies a specific internal table name in the Timberline Office database.
field nameRequired. This argument identifies a specific internal field name. The field name must identify a valid field for the table identified by the table name argument.


key 1 ... key nOptional. These arguments provide the values of the primary key for the specific record desired. The number of key values and their meaning will depend on the table that was identified by the table name argument.

Remarks

To identify a specific record in the database, you must supply a value for each of its key fields.  If too few key values are supplied, the first record in the table matching the key fields that were supplied will be used.  If too many key values are supplied, then the extra key values will be ignored.  

If there is no record in the table with key fields matching the supplied values, the function will not return a value.  In this case Excel may display a value such as zero or a date, depending on the cell format.

Example

Click here for examples.


See Also



Content updated 12/3/2008
Copyright © 2008 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.