-
Sep 4th, 2012, 08:11 AM
#1
Thread Starter
PowerPoster
Inventory Audit for Library
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|