Hi Guys,

I have a table called Books(BookID, Title, ISBN) etc. I have a transaction table(ID, BookID, MemberID, CheckedOutDate, CheckedInDate) that tracks if a book is loaned out.

Now I need to do an Inventory audit. Basically, I list all the books. The librarian has to scan books one at a time. As they scan the corresponding book is ticked of on the list.

My question is, what fields or tables do I need to add for the inventory audit. It needs to be as reliable as possible. Also, any other suggestions are welcome. Thanks