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