# Autocomplete by some fileds of different tables

**URL:** <https://discuss.elastic.co/t/autocomplete-by-some-fileds-of-different-tables/162552>\
**Category:** Elasticsearch\
**Created:** [January 1, 2019, 7:26am UTC](https://discuss.elastic.co/t/autocomplete-by-some-fileds-of-different-tables/162552 "2019-01-01T07:26:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hamidnch](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@Hamidnch](https://discuss.elastic.co/u/Hamidnch)\
**Post date:** [January 1, 2019, 7:26am UTC](https://discuss.elastic.co/t/autocomplete-by-some-fileds-of-different-tables/162552/1 "2019-01-01T07:26:53Z")

</div>

Hi every body.  
I'm new in elastic search world.  
And I want to use **Nest** in [Asp.net](http://Asp.net) Core 2.2.  
I want to change **NopCommerce** search to **auto suggester**.  
But I do not know, how to create **INDEX** by variant fields of different tables(for example: product name, category name,producer name fields of Products, Categories,Producers, Product attributes, Product Special Attribute tables)  
for the result, I want when I typing(for example) "soft" , then suggest me all products in software category, or when I typing "snapdragon", then suggest me all Mobiles that have "snapdragon" in it's product attributes.  
On the whole, how to create INDEX, how to update INDEX after Delete,Update and Insert actions.

Please advice me, if possible.  
Thanks a lot.  
[BEST REGARD]

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 29, 2019, 7:39am UTC](https://discuss.elastic.co/t/autocomplete-by-some-fileds-of-different-tables/162552/2 "2019-01-29T07:39:04Z")

</div>

Closed on January 29, 2019, 7:39am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.