Forum Discussion
Updating a DB using a running file
Hi! So, I have a database of unpaid loans. And I need to update this database to 1) add new loans; 2) update partially paid loans; and 3) remove fully paid loans. To simplify my illustration,...
To be honest, I find it a bit confusing. Am I right in concluding that:
- List B is a list of all current loans including recent additions and updates?
- List C is a list of all current loans, no longer including recently fully paid loans?
If so it can be done. The number 2 requirement can also be done.
Sorry about that. Basically, these lists come from a bigger database to which I do not have any access. As such, I am only provided a streamlined version. As the bigger database is updated daily, I also receive a streamlined version on day-to-day basis. That is why Lists B and C appear to be similar to List A, but List A is the list that is in my database. I have to update it based on the data found in the succeeding lists as it comes.
List A was sent to me Day 1. List B is Day 2, and List C is Day 3.
Hope that clarifies things.
- If all lists are lists of all current loans, I see no reason why you should not just use the most recent list.