In Leave request table 1. I created a leave from 09/08/22 to 31/08/2022 so deducted days will be 20 it is based on custom calendar . 2. Another leave created from 01/09/22 to 17/09/22 so deducted days will be 15 it is based on custom calendar. Total leave per year is 30 days Deducted days total is equal to 35 which is 30 is paid and 5 is unpaid When leave is approve then record is created on another table Can we create 1 record into 2 record into another table (example 2. point is divided into 2 records on another table and on another table deducted days will be 10 is paid and 5 is unpaid ?