>For example, I want my user to select a state (Florida). The grid (bound to a view) would show only items with Florida. Now when the user selects Nevada, The grid shows only Nevada items.
>
>Sounds simple but I could use any pointers to make this transaction clear. I have success with a query that's hard-coded with "Florida". I am missing how to assign a variable to the query so that it refreshes when the user leaves the prompting box.
>
>p.s.I posted this under Code & Commands but I didn't see it displayed, (after 30 minutes). This is my first call for help on the VFUG.

What about using parameterized view, say

SELECT STATES.STATE FROM STATES ;
WHERE STATES.STATE = ?MyStateValueSelectedFromPromptingBox

Nick