title: FRM-40501 unable to reserve record to update
body: <p>I made a table called groups that has these columns</p>
  
  <pre><code>client_id, 
  course_name, 
  group_number, day
  </code></pre>
  
  <p>the primary key is (client_id, course_name)
  so each group number may has many clients
  and i want to make a query in my form that displays only the distinct value of group_number and when i update the "day" field it should update day column in all rows with the same group number(for all clients)
  so I used from clause query and wrote in it:
  <strong>SELECT DISTINCT(GROUP_NUMBER), COURSE_NAME, DAY FROM GROUPS</strong> </p>
  
  <p>when i update this form in run time it gives me this error "unable to reserve record to update" what should I do?</p>