...
This will produce an SQL statement like this:
| Code Block |
|---|
SELECT DISTINCT CNAME, CATID FROM CATEGP WHERE CNAME = ?
|
...
By completing the choice parameter value we can see our statement should return only the items named "Soaps". Multiple You can have multiple "parameter value" properties, however this does require multiple choices selection criteria. These can be added by right-clicking the choices parameter value property name and selecting "Add Another Choices Parameter Value":
To find more information on the choice selection criteria and choices parameter properties, view the Parameter Markers section here.
...