I tried several different configurations of a query where I want ALL records from table "Families" but want to access the landline and cell phone numbers from a related table for the family "Head of Household" (FamilyHoHID).
The query depicted below runs okay but it seems to run slow when used as the RecordSource in one of my forms leading me to believe there's a better way to design the query?