Copying Data

[loveforfire33]

hi,

i have a library system i am developing and need to perform the following action. i belive i have posted this in the right section - but apologies if not!

i basically have the current loans as part as part of a books table - with the loan being recorded in the row of an actual book.

when the book is returned i would like to move the information stored (issue date, loan date, borrower id) to be moved into a second table called loan history where the data can be stored for analysis with reports etc. and then the current loan information stored in the books table to be cleared.

any ideas at all? im really stuck and would be most gratefull for any help!

thanks
scott

 

[ezfriend]

When a book is returned. Let's say, user click on a "Return" button, you can instruct (VBA) the button to

1. Insert a row of that information into your second table
2. Verify that it is there using the some sort of unique id for the current record
3. Delete from the first table if it is in the second table

You will need a unique id to identify this row of data. ISSUE_ID, maybe???
This will allow you to identify that unique record (#2)

Btw, not sure why a second table is necessary. Maybe just an indicator on the first table, "Return=Y/N" and a return date