lcActive = "Y" lcName = "George" Select * from customer where active = ?lcActive and name = ?lcNameTo answere your other view question, a simple way to do this would be as follows,
llSupervisor = .t. Select * from customer where active = ?lcActive and ; iif(?llSupervisor,suppername = ?lcName,name = ?lcName)>The view I have loaded to my form uses parameters to filter by name and if the record has a field set to active. Now I would like to put a function on the form to view a record that has the field set to inactive. How is this done?