Good day, I am trying to create a database which allows me to assign tasks to my officers for specific time periods. Some tasks take days, weeks and even months and as such during that period, If i try to assign them with another task, the system will notify me that this Officer is already a task and would also recommend who is available during the period required