Answers.Body: <p>Solved it.
  Missing primary key &amp; messed up ID's in civicrm_value table</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-19T05:18:48.787Z
Answers.LastActivityDate: 2022-08-19T05:18:48.787Z
Answers.UserDisplayName: LesleyJill
Body: <p>Civi 5.51.0 wordpress 6.01</p>
  <p>Best explained with an image I reckon. Each time I edited this contacts country of birth another entry appears in reports (same with exports from search - multiple rows created).
  Doesn't happen if I edit standard fields, only custom fields of any type ie text, date, option,Y/N etc
  Making reports and export unuseable HELP
  <a href="https://i.sstatic.net/gYPZs.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/gYPZs.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-18T09:23:47.343Z
Comments.Text: What kind of report are you using? Ist it maybe a report based on log entries? Or on activities?
Comments.UserDisplayName: Fabian
Tags: <custom-fields><multiple-records>
Title: Editing custom field creates multiple entries in reports and exports with same contact ID
ThreadText: # Editing custom field creates multiple entries in reports and exports with same contact ID
  
  (Asked by: username_0 on 2022-08-18)
  
  Civi 5.51.0 wordpress 6.01
  
  Best explained with an image I reckon. Each time I edited this contacts country of birth another entry appears in reports (same with exports from search - multiple rows created).
  Doesn't happen if I edit standard fields, only custom fields of any type ie text, date, option,Y/N etc
  Making reports and export unuseable HELP
  [![enter image description here](https://i.sstatic.net/gYPZs.png)](https://i.sstatic.net/gYPZs.png)
  
  **Tags:** custom-fields, multiple-records
  
  > **Comments:**
  > **username_1**: What kind of report are you using? Ist it maybe a report based on log entries? Or on activities?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-08-19. Score: 1
  
  Solved it.
  Missing primary key & messed up ID's in civicrm\_value table
  
  
  ---
  
  