You can use the lookup field (an advanced element) when you create and maintain forms:
Use a lookup field and the JavaScript function named ca_fdDoFieldLookup(fieldId, reportId) to populate fields based on user input to a report data object.
You configure the lookup field to prompt the user to enter the data, such as a user ID, asset ID, or city, used in the query of the data object. The data object queries your data source, based on the user input to the lookup field, and uses the results to populate the fields you specify.
When the user clicks the associated icon (magnifying glass) for the lookup field and enters the requested data, the query runs and returns the search results in rows. Each matching value appears in a row. Users review the rows and select the row they want. When the user selects a row, the results from that row populate the matching fields on the form.
For example, the lookup field may prompt the user to enter a user ID. The query then searches the database for the first name and last name of that user ID and presents them to the user in the search results. The user can select one row in the search results to populate the corresponding First Name and Last Name fields on the form.
|
Copyright © 2013 CA.
All rights reserved.
|
|