How to search on lookup table value in a tabular report

[MikeN]

I have a tabular report containing afield that has a lookup table associated with it (1 to many relationship).  How do I do a search in the table for rows that have a value that is contained in a lookup table.  E.g.I have lookup table of Department ID & Department name.  In my tabular report of employees with Employee ID, Employee Name, Department ID (each employee belongs to a particular department) I want to search for Employees belonging to a department, using the department name rather than Department ID.  And I want the search to be able to use "Contains" e.g. bring up all Employees with "Admin" in the Department name, as there are a number of Departments with "Admin" as part of their name.  e.g. Postal Admin, Finance Admin. Apologies if it's a rookie question !

[kpcollier]

I'm not exactly sure at the moment what you would need to do for a Text Field... but if you use a Dropdown Element for this, it is easy.  In your DataPage Wizard, go to the Configure Search Fields page. Select the field you want to search by (in your case, Department). Change the field to Dropdown, and change Source to either Both or Lookup Table or View. I like to use both because I put an empty option in the Custom Values section to allow the user to search 'all'. 

On the Lookup Table tab, select the department table. Change Field For Display to Department Name and change Field For Value to Department ID. This will show the Departments to the users as the Department Name, but Caspio will take in the value of the ID. 

[AtayBalunbalunan]

Just to add, you may also use the AutoComplete form element and configure it with the below settings.