What I'm working on is a video rental project in visual basic 2008.
I have a local database which contains info on DVDs, Members and a table for current rentals.
The columns i have in the current rentals table are:
MemberID | DVDID | DaysOnRent | DateRented | DueDate | Overdue | TotalPrice
I have this data displayed in a datagridview, but the user adds it through a seperate form (called add a rental) with a 'details' view of the table on it. I've written code to automatically determine the TotalPrice and DueDate of the DVD in the add a rental form.
I don't know how to get the database to automatically detect when a DVD is overdue (when todays date is greater than the DueDate).
I want it to check it in the column "Overdue" (which is boolean)
..so basically what I'm asking is how do i update the overdue column automatically depending on whats in the DueDate
I'm fairly new to programming and just can't figure out what to do here.. any help would be greatly appreciated! :)