title: Subform To Return all records containing a string in Master Form
body: <p>I cant think of anyway to do this, but I'm working on a <code>database</code> set up in 1995 with re-occurring customers with some having slightly different names and my client wants all records that contain the customer name to be displayed in a subform. This is only a <code>flat file database</code> with the fields </p>
  
  <pre><code>Job_Number (pk), Customers, Date, and details
  </code></pre>
  
  <p>I set up a subform with a simple <code>master child link</code> to the <code>Customer</code> field and the subform returns all records matching the <code>customer name</code>, but not all records that contain the string Customer.</p>
  
  <p>Is there any way to do this, I don't want to have to set up a separate Customer table and find all the unique customers, because this database has 15000 records.</p>