Hello, I've been asking alot of questions on this board recently as I am attempting to set up a library database system, and I don't know much about Access. I have gotten a lot of help, but I'm beginning to doubt if my design will work out.
The way I have it set up now is that there is a table bookList, and a table transactionHistory. The use can select a book from a combo box, type in the name & email of the person checking the book out, and save this data to the transactionHistory, with a few other fields such as date of checkout, date due, etc. Similarly, there is a form that allows the user to select the book from a list, enter in the email of the person returning the book, and this information is likewise saved to transactionHistory. I am trying now to get a list of books checked out, along with checkout information, but I do not know how to combine the informatiopn from different rows of the transactionHistory table such that it can see which books have been checked out & returned, and which have only been checked out.
I'm not sure if the only problem is not knowing how to perform this operation, or if my general database design is bad. Any suggestions would be appreciated, if I haven't explained well the requirements for the db or the problems I'm having please let me know and I'll try to explain it better.
Thanks,
Mike
The way I have it set up now is that there is a table bookList, and a table transactionHistory. The use can select a book from a combo box, type in the name & email of the person checking the book out, and save this data to the transactionHistory, with a few other fields such as date of checkout, date due, etc. Similarly, there is a form that allows the user to select the book from a list, enter in the email of the person returning the book, and this information is likewise saved to transactionHistory. I am trying now to get a list of books checked out, along with checkout information, but I do not know how to combine the informatiopn from different rows of the transactionHistory table such that it can see which books have been checked out & returned, and which have only been checked out.
I'm not sure if the only problem is not knowing how to perform this operation, or if my general database design is bad. Any suggestions would be appreciated, if I haven't explained well the requirements for the db or the problems I'm having please let me know and I'll try to explain it better.
Thanks,
Mike
