Over Christmas I've taken on the task of putting together a database for work; I don't have a deadline but it would be nice to have something to show in the new year.

The database I am intending to build is to track the location of wheelchairs in the hospital where I work. Its a fairly simple system. But I'm a fairly simple person when it comes to databases - but within our department I am probably the most computer literate person so I seem to be the ideal candidate.

The chairs have unique numbers which will serve as the primary key. Where I am having difficulty at the moment is when I get to the location of the chairs. There are four locations where the chairs can be - 'On Site', 'Off Site', 'Out of Service' or 'In Storage' and each location requires different information to be entered.

I will have a table of all the chair numbers which will include all relevant/required information regarding each chair. This is more so the database can be searched to see what is currently available.

Ideally I want to create a database that serves two purposes. Tracks current locations, and enables everyone to see whats available. For tracking purposes, I imagine that someone would enter the chair number and then chooses the location where it is. My problem is choosing the location, Ie; 'On Site', I have no idea how to get the 'On Site' table to load for the information to be entered?

I have based this on one table for 'chair information' and another for each of the locations.

Any help would be greatly appreciated because quite frankly, I need it! I'm slowly wrapping my mind around the task but at the same time, lack the knowledge with Access to do it on my own.