TableLookup Function

Updated May 17, 2023 07:01

Returns the value from a table for the first row that satisfies the field matching criteria.

Syntax 1

	Returns the value from a table for the first row that satisfies the field matching criteria.
	TableLookup(table, returnField, matchField, matchValue)

Arguments:

		table	DataElement - A table.
		returnField	Field - The field value to return.
		matchField	Field - The field to match.
		matchValue	Expression - The field value to match.

Syntax 2

	Returns the value from a table for the first row that satisfies the field matching criteria.
	TableLookup(table, returnField, matchField, matchValue, default)

Arguments:

		table	DataElement - A table.
		returnField	Field - The field value to return.
		matchField	Field - The field to match.
		matchValue	Expression - The field value to match.
		default	Any - The default return value.

Remarks

Example: TableLookup(OrdersTable, "CustomerID", "OrderID", ID, "City") returns 42.

Example: TableLookup(OrdersTable, "CustomerID", "OrderID", ID, "City", Location.City) returns 42.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.