Hello,

NEWBIE here looking for assistance.

My MD has asked me to create what he considers to be a 'simple' db in Access for us to store the location of some keys (that we use for testing locks).

Problem is, it's been ages since i did anything like this and just don't know where to start (and i suspect it's not as easy as he thinks).

This is the BRIEF he's given me:

On having an order that requires a master key the operator is able to go to a database and select ‘search for key’ he then scans the barcode of the lock differ from the order. The database then either gives the location of the key (e.g. Cabinet 1, DRAW 2, row 3, column 2) or tells the operator that there isn’t a key or that the key has been removed from storage.
The operator then finds the key and scans a barcode ATTACHED to the key to confirm he has removed the key.
The database now stores the fact the key has been taken
When the key returns back (or a new key is produced) the operator tells the database he wants a location for a key and scans the barcode on the key. The database gives the operator a location, this location does not need to be the same location as before.


I envisage it being just one table with two fields "MasterKeyDiffer" and "Location"

My problem is how do i get the db to search and find the relevant key (or flag that one doesn't exist), and then when it comes to putting it back, select an appropriate location?

I assume some sort of code is required.

Any help GREATLY appreciated.