Subform to Main Form Record Problem

  • Thread starter Thread starter Adriana
  • Start date Start date
A

Adriana

I have a main task table with a subform that has task elements and another
subform within the task element subform to record multiple employees. The
form is showing the same top level record two to three times depending on how
many subtasks I create. How do I get the form to only show the main top
level record once if I have a few records within the subform? My form is
based on a query by the way.
 
It's likely the query that is causing the problem. An INNER JOIN to the
task element table, maybe? Why don't you post your SQL statement that the
mainform is based on. Or why not just use the 'task' table as its
recordsource?
 
Back
Top