> > I am setting up a grid to display my Customer record and the grid only > display customer name and phone number. I am using a combo box to narrow > down the record selection which only display customer with the name start > with "John" and the grid will only display the customer with "John". So , > where do i need to set the condition beside of using query view. > > The grid that i am seting now display all the record and i need to use the > scrollbar to scroll down to the correct record. > > Could anyboby help me on this problem ? I am in trouble now ! > > Thank You. select * from table where firstname = "john"; is the correct syntax and table is what you call your table inside your database and firstname is your variable row that john sits in