# Prevent duplicate records

**URL:** <https://community.stackerhq.com/t/prevent-duplicate-records/832>\
**Category:** How do I?\
**Tags:** troubleshooting\
**Created:** [September 3, 2024, 10:11am UTC](https://community.stackerhq.com/t/prevent-duplicate-records/832 "2024-09-03T10:11:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rutgerhofste](https://avatars.discourse-cdn.com/v4/letter/r/ba9def/32.png) [@rutgerhofste](https://community.stackerhq.com/u/rutgerhofste)\
**Post date:** [September 3, 2024, 10:11am UTC](https://community.stackerhq.com/t/prevent-duplicate-records/832/1 "2024-09-03T10:11:26Z")

</div>

Hi Stacker community,

I’m struggling with limiting my users to create duplicate records. Say I have 3 tables in Airtable, colors (blue and red), numbers (one and two) and combinations of those. The combinations table should only allow unique combinations so if blue - one already exists, it should limit that option in stacker when you want to create a new record.

Here are links to the test airtables:

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/fe01b0be1c2cc796649bad8b9e0fd478f20ce768.png)

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/b779a3cf2886d5d2575760f757f907af1090aa82.png)

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/f056fd89cc6b9fdf913c102bbdb06dbd59980f27.png)

In Airtable I added the lookup fields and created conditions for the linked record in my combination table.

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/a0a5efaf3fc37ae939282169bed170e2731ea5f6.png)

and for the color linked record:

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/da134d9ef83f6ed8dab6544e5c0382510059fb4a.png)

and the result is as expected. I can only select options that are not already present in the combination table. So if Blue-One already exists, if you select Blue, you can only link to “Two” and not “One”.

Now I want to minic this behavior in Stacker. However I doubt if this is possible as the “record” does not “exist” before you click save. I tried setting up the limitation in Stacker, but this only works in edit mode, not when creating any new records.

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/d0551cdc6d32b4c80170806e2905dd9b8d5c5e9c.png)

Any guidance from this community or stacker team would be helpful.

---

<div class="post-metadata">

**Author:** ![Brittany\_Tickner](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/brittany_tickner/32/460_2.png) [@Brittany\_Tickner](https://community.stackerhq.com/u/Brittany_Tickner)\
**Post date:** [September 13, 2024, 4:48pm UTC](https://community.stackerhq.com/t/prevent-duplicate-records/832/2 "2024-09-13T16:48:38Z")

</div>

Hi There!

You could use the Dynamic data filtering in create forms, try making the second field its own widget: [https://support.stackerhq.com/hc/en-us/articles/17261289587603-Apply-dynamic-data-filter-to-Link-Fields](https://support.stackerhq.com/hc/en-us/articles/17261289587603-Apply-dynamic-data-filter-to-Link-Fields)