I am new to InfoPath forms. I have a basic idea that InfoPath forms can be used to capture information related to list columns and the data can then be stored in the list on a SharePoint site. However I want to design an InfoPath form which can be used as a search form for searching values in the list.
E.g I have columns like Name and Department in a list. I want to create a search form where if the user enters only Name, it should search for FieldName contains Name; if the user selects Department, it should search for FieldName equals Department, if the user enters both Name and Department, it should put an and condition for both. THis functionality is not possible OOTB for MOSS 2007. So thought to check if it is possible with InfoPath forms.
Any help would be appreciated.