I have a table called tblLoans. One of the fields is labeled LoanStatusID and it gets data from a supporting table called tblLoanStatus.
There can be many different types of loan statuses. For example, a loan could be open, pending or in bankruptcy. There can only be one status for a loan at any point in time, however the status of loan can change. For example a loan could be pending and then become open.
Let’s say there is a loan with a Pending status. There are many reasons for a Pending loan.
I considered the following design:
This is as far as I get and need help going forward. I need to track the LoanStatus so I suspect at least another table and some work on the above. Please keep in mind that Loan Status could be something besides Pending, e.g. Open, Close, Bankruptcy, Repossession, Place for Collections, etc.