Help me sorting out MS Access related problem...

[mxnmx]

Hello Everyone
I'm writing a program for a Library that lends out books for long & short term. And I'm stuck & need help...if lets say there are 20 people using the library, how shd I enter the books they borrow, I mean one person can borrow upto 10 books, so how do I make sure that all the books that he borrows go into his account only. I'm using MS Access...and woukld like to do this- if I enter the person's ID into the program it should return all the books he has hired from the library & the ones he currently has...so my basic problem is how to store the data, I mean, how do I ensure that all the books he's borrowing just go in his profile or account...shall I make one table for each user and then all the days he borrows, I keep making fields for them...please help

[aidan]

I would do this:

1 table for users: ID, Name

1 table for books: ID, Name, Category

1 table for borrowing events: bookID, userID, Date taken out, Date returned.

To find out what's in a person's account, query for all the borrowings without a return date for that person's userID.

[mxnmx]

Thanks Aidan, I will certainly try this out!