Return Item Query

[acwest]

Hello,

I am creating a basic library database that loans out CDs to borrowers. At the moment i am trying to create a return query so CDs can be returned. I need to Append the values (AccessionNo, BorrowerID, DateIssued, Date Due) into the LoanHistory table whilst also adding data to the DateReturned field in LoanHistory. The data that was appended to the LoanHistory table from CDCopy needs to then be deleted so the book can be loaned again.

Attached is the Database

Any Help appreciated!

 

[Khalid_Afridi]

...The data that was appended to the LoanHistory table from CDCopy needs to then be deleted so the book can be loaned again.

Hi acwest, instead of deleting data from from the LoanHistory table from CDCopy table, just consider to change the status of the cd to be "Returned", "Borrowed" etc.

Deleting of any record is not a good idea for inserting new records, rather you can make the CD's status to "Returned" & "Borrowed". by doing this you can also reduce the number of tables in your database.