Library Database Structure

[rgreene]

HELP!! I'm going insane

We have recently started a "library" at my company and they have asked me to create a database so we can check out the books. I have started this project over 3 times now and I'm starting to go nuts. I think I need someone to look at my "Foundation" and see where I'm going wrong and shed some guidance on what I need to do. Anyone willing?
If I can get the basics to work properly I can add the "fancy" stuff later

My plan:
Enter and view book info on frmbooks. When I find a book to check out I click the checkout button and a form (frmstatus) opens. It has the current records information already in it (BookID and BookName) on this form (frmStatus) I then want to be able to access the EmployeeName combo box choose an employee from the list and have it automatically populate the Department and email fields (which are already entered in on the tblEmployee)

Sounds very simple doesn't it. For some reason I can't seem to figure out what I'm doing wrong.

If your willing let me know and I'll email you the zip file. I tried to attach here but it only allows 100KB size and mine is 800 and some KB.

Thanks for everything,
Rick

 

[WayneRyan]

Rick,

You're gonna have to either post your table structures or your database.

If you use:

Tools --> Database Utilities --> Compact/Repair
Then ZIP

Then it should be small enough to attach. Remove all graphics and stuff
not related to your problem.

Wayne

 

[rgreene]

Here it is

I've attached the zip file

 

[Parker]

I've attached the zip file

Here ya go.

Sorry it took a while but I've been a bit bogged down.

Lots you could do with this one but it should get you on the right track.
2 versions (97 & 2000) All graphics have been removed so the main form looks a bit empty.