I would create a new field in the Personnel table. Something to the nature of "status" where you could set a status for each personell member; The standard value "Auto Enter Data" would be "Active" but their would be a dropdown where you could choose "Active, Inactive"
Then in the table the Daily Reports layout is based on you create a text field called g_Active and make sure you set it's storage to global.
Give it the value "Active" And that value will show up in this field on every record.
create a new table occurrence of the Personell table (the two green plus signs) and call it Personnel_Active
Relate it to the Daily Reports table in the following way:
Personnell_Active::Id-----[=]-----DailyReports::PersonnelIdFk - FK Stands for Foreign key
This way you'll only be able to see active personnell from your Daily reports table.
Make sure you base your value list on the Personell_Active TO (Table Occurence) and select the "Show only related values from - DailyReports"
This should give you only the active personell in the dropdown.
If you have any problems let me know.
Another option is to set up a calculation field in the employee table:
If ( Status = "Active" ; Prsonnel::ID )
Then base your value list's values on this field instead of the ID field.
But less flexible than a relationship based conditional value list, so you have to consider both the pros and cons. That's why I came up with this tutorial on conditional value lists: