Access Templates

[wup]

I'm using Access '97 and I was tasked with creating a simple db for tracking items in and out of storage. I want it to work pretty much like a library where someone can check in/out the items. When the item is checked in, it will have an assigned location (like A1 or B2, etc). Each time the item is checked in, it will be assigned a different home location. Although I've fumbled around in a couple of existing Access '97 databases, I've never created on from scratch. Is there a template out there that I could just plug my info into? If not I'd appreciate any ideas of how to set this up.

[RuralGuy]

Maybe this link will be useful: http://allenbrowne.com/AppLibrary.html Have you check the on-line templates yet?

[Microsoft Access Database]

You could have a table of locations and use a combo box to display and assign them. You will also need a table of items with a field for location. This will hold the ID of the comobo box value.