I would like to create a database to track the movement of equipment. Each of my company's employees has a barcoded ID badge and each piece of equipment has a barcoded equipment id.
Here is what I would like to track:
1. Associate ID (checking equip out)
2. Equipment ID (going out, and time back in)
3. Equipment Damages / Malfunctions
This question is doesn't require a ton of detail, just direction on table design/setup and form setup suggestions.