AnsweredAssumed Answered

One to many Report

Question asked by jfhump on Mar 27, 2014
Latest reply on Mar 27, 2014 by philmodjunk


One to many Report


     I have 2 tables:

     Audit (fields:  AuditID, Supervisor, EmployeeName)

     AuditItems (fields:  AuditItemID, FKAuditID, Note, Date)

     There is a relationship between the tables that links AuditID to FKAuditID and the relationship allows creation of records.  When I perform a find on Employeename, sort by summary fields and preview the report, it has all rows not the find criteria.  It seems as thought I have to do my find in the report layout to get the correct records from AuditItems. I'm not sure what I'm missing here and would appreciate any assistance