1 Topic by v_pozidis (edited by v_pozidis 2020-05-07 15:09:36)

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

Topic: Stop duplicates with relationship

when I have tables with relationship How can I avoid duplicate record when adding in tablegrid directly ? There is a example (with the help of  derek) , please feel free work on it.

Post's attachments

Attachment icon editable tablegrid insert(1).7z 274.43 kb, 254 downloads since 2020-05-07 

  • Registered: 2015-11-13
  • Posts: 652

Re: Stop duplicates with relationship

v_pozidis,
I believe you have the relationship backwards in your database. So I switched the relationship and added script to incorporate the related field in the duplicate check.

Post's attachments

Attachment icon editable tablegrid insert_Revised.zip 337.76 kb, 266 downloads since 2020-05-07 

3 Reply by v_pozidis (edited by v_pozidis 2020-05-08 15:02:32)

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

Re: Stop duplicates with relationship

Thanks
I think that i found an error when i try to edit the record it dosn't allow  the correction. This is the example with a singe table
Can you please check it?

Post's attachments

Attachment icon editable tablegrid insert(1).7z 274.43 kb, 256 downloads since 2020-05-08 

  • Registered: 2015-11-13
  • Posts: 652

Re: Stop duplicates with relationship

v_pozidis,
Project is modified. It is pretty much the same code as in my previous post.

Post's attachments

Attachment icon editable tablegrid insert_Modified.zip 337.11 kb, 309 downloads since 2020-05-08