The rowset containing lookup values for a field.

Property of



Use lookupSQL or lookupRowset to implement automatic lookups for a field. For information on how automatic lookups work, see lookupSQL.

The simpler implementation is to set the lookupSQL property. This automatically generates a lookup rowset, which you can reference through the lookupRowset property.

The more advanced technique is to generate your own lookup rowset, which must follow the same structure as detailed for lookupSQL. Then assign a reference to this rowset to the lookupRowset property. Doing so releases any internal rowset generated for lookupSQL, if any. This technique might be used if you want to use the same lookup for multiple fields.