# Adding Unique data from one table to another

**URL:** <https://community.thunkable.com/t/adding-unique-data-from-one-table-to-another/1660012>\
**Category:** Questions about Thunkable X\
**Tags:** database\
**Created:** [December 24, 2021, 4:44pm UTC](https://community.thunkable.com/t/adding-unique-data-from-one-table-to-another/1660012 "2021-12-24T16:44:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 24, 2021, 4:44pm UTC](https://community.thunkable.com/t/adding-unique-data-from-one-table-to-another/1660012/1 "2021-12-24T16:44:30Z")

</div>

Hello Thunkers!  
So, i just came across this problem where I retrieve data on textbox change event from database(basically a search box), makes my app works slow, because this database(Order Report) contains several repeated entries hence making it slow to filter. So, I was looking to create a new table(Client Report) for this five text boxes, where if when I click confirm Button it checks:-

1. If, data already there in client report than it should not add.
2. If, data not present in client report table, this 5 textboxes data should be added to the table.

Coming to retrieving data via text box i.e., search box, when I type into GSTIN text box it should show me data from client report and not from order report table.

Let me explain sequentially…  
As my order screen opens up, I type in GSTIN textbox, as I type a list viewer pops up, this list viewer should only contains value from client report table(Need solution here). if data is there i click on list box and the textbox gets filled with the clicked item. If not it’s okay it will be typed.(Done with this part).  
Then I fill other details, and when I click confirm button, the gstin textbox should check if that record is in the client report or not.If not it should add. maybe I’m clear 😅 🤔

 ![WhatsApp Image 2021-12-24 at 21.48.10](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/f/ff3ef06f378baea532b8300c4610920917d322ba.jpeg)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [March 24, 2022, 4:44pm UTC](https://community.thunkable.com/t/adding-unique-data-from-one-table-to-another/1660012/2 "2022-03-24T16:44:56Z")

</div>

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