Is it possible to have a data retrieval rule in which the where clause should process a condition with a multi-value field
For example, I have a field for departments and the values are Analyst, Developers, Testers, Admins
Is it possible for me to pass an indirect arguement such as departments to get the details for developers?
SELECT * FROM tblDivisions where department = #dictionaryname.fieldname#
SELECT * FROM tblDivisions where department = 'Developers'
Also, I am displaying the result of a data retrieval rule as checkboxes and they are available vertically even if I changed it as Horizontal in the display properties of the form. Is there any way to have the resultant checkboxes horizontally?
Any help is greatly appreciated!