Hello all,
I am looking to create a database and was looking for suggestions on how to go about it. I work in a tech field and build equipment that I loan out to employees. I need a database where I can enter various cells of data such as brand of item, serial number, firmware, etc. I then want this record to be kept as a specific record. I then loan the equipment out to an employee and when they are done, they return it. I need a way to keep a full record of who it was loaned out to, when it was loaned out, when it was returned by the employee. Then when it is loaned out to another employee, I need it to keep a separate line for each loaned out period. So basically say I have Item 1 that contains parts x,y and z. I need to have a ongoing list of when I loaned out item 1, to whom it was loaned to and when it was returned. Sometimes I take parts from item 1 and put them into item 2. So I would like the database to be able to then show item 1 as retired or closed and then a new record created for item 2 as it's changed its internal components. I will still need to be able to check on item 1 in the history to see when it was loaned out, returned etc. There may already be a database or template that I can use to accomplish this, or maybe i need to do it from scratch, but wondering if anyone can guide me. Thank you!!