November 21, 200619 yr :P I need to have FMP automatically delete duplicate records down to a specific field when generating a report! My database has field like division, department, goal, objective, tasks... When I generate a report that tells a division each objective it has, there are many duplications because there is a record for each task (which may be 4 to 6 under each objective) I can clean these manually but there must be a way to auto delete duplications at the objective field level for this report!?
Create an account or sign in to comment