title: At most one record can be returned by this subquery
body: <p>I am facing this error in my SQL select query. How can I fix this?</p>
  
  <p>When I run this query and if there is only one record in <code>HR_info</code> table regarding my query then it show that result in combo box. If there are more than one record in this table then it show this error.</p>
  
  <pre><code>sSQL1 = "SELECT HR_Info.HR_ID, 
              (select hotel_name from hotel_info 
               where hotel_id = (select hotel_id 
                                 from hr_info 
                                 where hr_info.group_id = forms!pasenger_detail!group_id)) 
           FROM HR_Info 
           WHERE (((HR_Info.Group_ID) = [forms]![Pasenger_Detail]![Group_ID]));"
  </code></pre>
  
  <p>here is the hotel_info talbe data
  <img src="https://i.stack.imgur.com/arIaE.png" alt="enter image description here"></p>
  
  <p>here is the hr_info table data
  <img src="https://i.stack.imgur.com/yu5fR.png" alt="enter image description here"></p>