title: Linking two Fields in PHP
body: <p>i have two tables <strong>Loan Application table</strong> and <strong>Loans table</strong>. There is <strong>status option</strong> and <strong>date loan was applied</strong> section. After status has been chosen as Pending from the dropdown field and date chosen and loan application saved, it goes under the loans section.</p>
  <p>Now, admin has to go and approve the loan and pick the date the loan was approved under the loans section but date can be chosen for the approved date but the status cant be changed to approve because it shows pending. Please what can i do so when i select the date for approval , the status should change to approved automatically</p>