Link to home
Start Free TrialLog in
Avatar of Everwulf
EverwulfFlag for United States of America

asked on

What direction show I be looking at in building a equipment check out database

Right now we just have a sign out sheet created in excel. But we are looking at building a database to keep track of who, how often a piece of equipment is checked out, and when it is checked backin. We would like to keep it in the same format as our current check out sheet.

I figured I would need a table for the equipment with a relationship to a table for checking out and checking back in. But I am not sure if I should also have a table that is a merge of the two to get the report to display the way we currently have it.

I am open to any better ideas or better method of database creation.

I have attached the excel file we are using for our sign out sheet.
Equipment-Checkout-Sheet--New-.xls
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Everwulf

ASKER

Thats what I was hopeing for. I work from that direction. Thank you.