Title: Data Explore > Table > Search Settings
Last modified: May 21, 2021

---

# Data Explore > Table > Search Settings

 *  [rladha](https://wordpress.org/support/users/rladha/)
 * (@rladha)
 * [5 years ago](https://wordpress.org/support/topic/data-explore-table-search-settings/)
 * Hey Peter,
 * I like the options, where users can search across multiple fields, but there 
   are few fields which requires relationship with the lookup table.
 * In my edit screen, they are configured as lookup columns but not able to figure
   out how to display the lookup values instead of Ids in the search.
 * Screen shots:
    1. Table: (see black arrow) [https://drive.google.com/file/d/1u3V8SnvtQp0aPQjP1M26k02kMxs0edvj/view?usp=sharing](https://drive.google.com/file/d/1u3V8SnvtQp0aPQjP1M26k02kMxs0edvj/view?usp=sharing)
   2. Search: [https://drive.google.com/file/d/1jpuBRiN1lQQTBWPj7mPRGsZo18WCbqsM/view?usp=sharing](https://drive.google.com/file/d/1jpuBRiN1lQQTBWPj7mPRGsZo18WCbqsM/view?usp=sharing)
   3. Edit Screen: [https://drive.google.com/file/d/19kyDnTuPJQTn6elDk9PMYLHpIIvJGanF/view?usp=sharing](https://drive.google.com/file/d/19kyDnTuPJQTn6elDk9PMYLHpIIvJGanF/view?usp=sharing)
 * Let me know if you need require more details.
 * thanks
 * Rahim
    #ProudPremiumPlugOwner

Viewing 1 replies (of 1 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years ago](https://wordpress.org/support/topic/data-explore-table-search-settings/#post-14466059)
 * Hi Rahim,
 * To use lookup values instead of IDs, you need to go into your template and select
   the column you want to display. You might need to do this twice, once for the
   list table and once for the data entry form. This screenshot shows an example:
   
   [https://wpdataaccess.com/docs/documentation/project-templates/data-entry/](https://wpdataaccess.com/docs/documentation/project-templates/data-entry/)(
   see column Lookup)
 * Please be aware that you can use a view to concatenate multiple column values
   in your lookup.
 * Does this help?
 * Thanks,
    Peter

Viewing 1 replies (of 1 total)

The topic ‘Data Explore > Table > Search Settings’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/data-explore-table-search-settings/#post-14466059)
 * Status: not resolved