Field In an Input Record
If the field is located in an input record, the field can receive data from a column in the current row of a result set of a query. You associate the field with a column returned by a query.
Note: Column names are not available if you do not test the selected query. Instead, you must select a column number that is a one-based number of the position of that column in the result set.