To create a Custom Property Set, perform the following:
You must now define the custom property set fields
The fields you create here will be the prompts for the property set.
Notice that if you select a "Combo Box" prompt type, an "Options" button will appear. You must create a list of options that a user will be able to pick. To do this, click on the options button and enter all the possible options.
Repeat the process until all fields are defined.
Creating lookup fields:
Let's assume that the lookup field is called "City" and you wish to load the city names from a database table so the user can simply select from a list instead of typing the city name.
Here is an example of how your select statement would look like:
SELECT CITY FROM CITIES
If your table (CITIES) column names are different than the field names for your custom properties, then a SQL Statement like the following would be appropriate:
SELECT CITYNAME AS 'CITY' FROM CITIES
In short, the column name returned by the query must match the custom property field name.
Passing values to other custom property fields:
If you would like to return multiple fields from your query, then your select statement would like like the following:
SELECT CITY, STATE, ZIP FROM CSZ
If your custom property set has fields named exactly the same, selecting a row will automatically populate these three fields.
Passing values to the SQL Statement:
If you would like the user to be able to type in a partial entry in the lookup field to get all matching rows, then your select statement would look like the following:
SELECT CITY, STATE, ZIP FROM CSZ WHERE CITY LIKE '<%=VALUE%>%'
With the above statement, the user can enter a partial value such as "a" to get all rows where the city starts with the letter "a". In other words, the phrase '<%=VALUE%>%' will be replaced with what the user enters as a partial value.
Only the System Administrator and members of the “administrators” system user group can define custom property sets.