• Registered: 2021-06-07
  • Posts: 40

Topic: Avoid duplicates

Hi everyone, I would like to know how to avoid duplicates in a ComboBox without deleting the records because each time I enter data the name is also added and it fills the Combo (see photo). How to do?

Rahan57

Post's attachments

Attachment icon Doublons.jpg 11.39 kb, 86 downloads since 2021-10-29 

Rahan57

2 Reply by derek (edited by derek 2021-10-29 11:39:04)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,682

Re: Avoid duplicates

There could be a number of reasons for the duplicates.  Without seeing your project, it would just be guesswork.
Derek.

3 Reply by Rahan57 (edited by Rahan57 2021-10-29 12:24:22)

  • Registered: 2021-06-07
  • Posts: 40

Re: Avoid duplicates

Here is the project reduced to the maximum.

Post's attachments

Attachment icon Suivi véhicule.zip 642.55 kb, 141 downloads since 2021-10-29 

Rahan57

4 Reply by domebil (edited by domebil 2021-10-29 17:08:33)

  • Registered: 2014-11-13
  • Posts: 371

Re: Avoid duplicates

Try like this

Post's attachments

Attachment icon Suivi véhicule ok.zip 338.03 kb, 190 downloads since 2021-10-29 

Domebil

domebil's Website

5 Reply by Rahan57 (edited by Rahan57 2021-10-30 06:38:09)

  • Registered: 2021-06-07
  • Posts: 40

Re: Avoid duplicates

Thanks domébil, the program is working great.
Have a nice week end.

Rahn57

Rahan57

6 Reply by v_pozidis (edited by v_pozidis 2021-10-30 08:04:59)

  • Registered: 2014-09-06
  • Posts: 805

Re: Avoid duplicates

in the past I had the same question. Here is the answer from Dmitry
See the example   Check dublicate on Linked List

http://myvisualdatabase.com/forum/viewtopic.php?id=588

7 Reply by Rahan57 (edited by Rahan57 2021-10-30 09:45:49)

  • Registered: 2021-06-07
  • Posts: 40

Re: Avoid duplicates

Yes, I know this formula, but it is only used for duplicate "Titles" but prevents new data of the same "Titles" from being saved in TableGrid.

Rahan57