It sounds like you have a field or fields that require a unique value. It also sounds like you are looking for any records that have a value.
If the two records in the stated 2 processes, return the same Record ID, then of course you are getting the same number, and therefore the same key. This cannot occur as the field is flagged to be unique. This is what I can make sense of without seeing some code. Jody Bevan  > On Jul 30, 2024, at 03:03, stardata.info via 4D_Tech <[email protected]> > wrote: > > I use the command " Find in field " for obtain a unique id during a record > creation during TRANSACTION . > I have two process that use this command into transaction. > Process1 obtain a unique id and is in trasaction, the id is 1 > Process2 request an id with " Find in field " and have the same id number, > and in SAVE RECORD have an error of duplicate key. > > How i can do to solve this case? > > Thanks > ********************************************************************** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
