Seperating completed and not completed

[nycbigapple]

Hi, I have a tab called file, where employees read a report, they go to the DB and select the option that it has been completed. Now, let's say user John Doe has 30 records filled with completed and Not completed.

I am going to create new tab so that is called completed, so that all the reports that are selected read will be stored in a different subform.

My design, I have a M:M for employees and reports. How can I achieve seperating the two types? Do I need to create a new table?

Thanks,

 

[Remou]

How is your form set up? Have you considered creating a subform for you tab that selects only completed reports from the report table and setting the Child and Master fields for this subform to the Employee ID?