Re: Double patient cards

Hi Arnaud, Thanks for your suggestion. I have a great number of records so i have used this solution:    ALL RECORDS([PATIENT])    ORDER BY([PATIENT];[PATIENT]Surname;[PATIENT]Name;[PATIENT]BirthDate;[PATIENT]Sex)    $R:=Records in selection([PATIENT])    CREATE EMPTY

Re: Double patient cards

Hi Ferdinando, schematicaly: selection to arrays (ID, name, surname, date of birth, sex) for($i;size of array;1;-1) if (values $i # values $i-1) remove from arrays end if end for query with array (arrayIDs) and you have the duplicates -- Arnaud > Le 22 oct. 2022 à 12:04,

Double patient cards

Hi All, I use 4D V16, and in one application i need to find all patient that have the same name, surname, date of birth, sex. Someone have already do this feature? Thanks Ferdinando ** 4D Internet Users Group (4D iNUG) New