Syntax

(AfmPromptFld "table.field" [ strWhereClause ownerKeys ] )

Comments

Calls up the Select Values dialog on the given table and field.

strWhereClause is an optional SQL restriction limiting the records of the table that appear in the view.

strOwnerKeys is an optional list of values that must be part of the primary key of records that are listed.

Example

The following routine shows a selection dialog of rooms of type OFFICE on the 17th floor of building HQ. It prints the key values of the selected room.

(defun c:seltst ( / strWhereClause )
(setq strWhereClause "rm_type like '%OFF%'" )
(setq ownerKeys (list "HQ" "17"))
(setq selectedKeys
(AfmPromptFld "rm.rm_id" strWhereClause ownerKeys))
(if (not (equal selectedKeys nil))
(progn
(princ "\nSelected keys ")
(princ selectedKeys)
))
(princ)
)