When you assign actions to menu options in the Application Designer, you can specify WHERE clauses to limit the rows of data for that action. You can also use a feature that allows you to prompt the user for WHERE conditions by entering the following line in a WHERE clause: @'prompt'.
For example, you want to prompt the user for a customer ID number from the Customer table. In the "Where Builder" dialog box, select the custid column and use: = @'Enter Customer ID:'