i am developing a Library system, where user can borrow books and return them. i have a table in my DB called "borrowed books" it contains list of information about the borrowed book and the borrower, when the user returns the book the system should remove the record for that selected book.
the record is initially removed, but when i rerun the application, it is still there. i set the properties to copy if newer and removing records from other relations was successful except for this one.
the only difference is that this relation has a composite primary key. Any help is appreciated :)
i am using Access DB and vb.net