FilterComboBox for Filter drop-down

[AndrewLDS]

Is there a method to filter a combo box for a Grid widget filter (transformed to drop-down), similar to the FilterComboBox() for the form helper program?

For instance, if the below data source is for the Grid filter drop-down and I want to filter the drop-down to be 'Adam' if Adam logs in so he only sees Options A, B in the drop-down, what would I need to do to accomplish this?

Name	Options
Adam	A
Adam	B
David	C
David	D

[Johnny Major]

You could create a SQL UDF (User-Defined Function) that is used in the WHERE clause, or you could use vvIn_Virtual in your WHERE clause. The app variable referenced in vvIn_Virtual would be set in the application's startup program