title: SubForm exclusions Microsoft Access
body: <p>I have a practice database I'm developing in order to become familiar with access. I have created 3 tables, Employees, Computers and Warranty.  In the Employee Table there is an Eid (PK), First Name, Last Name and Location.  In the computer table there is an Eid(FK), Serial Number (PK) and various identifiers such as brand, size,etc.</p>
  
  <p>Problem
  I want the form to show only the employees who currently have a device followed by the devices they have displayed in a subform. *see below</p>
  
  <p><strong>Employee</strong>
  Rachel Downs
  <strong>Devices</strong>
  Dell Latitude
  Apple iPad</p>
  
  <p>Instead I get the following result </p>
  
  <p>If I choose sort by employee with a subform, each employee is displayed with the devices they own.  <em>Including</em> employees who don't have any devices.  I only want to display employees who currently have devices assigned.  Any suggestions on how to do this? fyi I used the form wizard to create the forms.</p>