what to do

[darceyoh54]

I work at a small office, where one of my main duties is to manage the Safe
Deposit Company. I have created a database for all of our customers and
their information. However, we have a lot of boxes, and I want to create
something that will tell me which boxes are open and closed. but, I want it
to somehow pick up the information that the box is closed when I input a new
customer into the access database. and if you haven't guessed, the box
number is part of the customer information. As I am self-taught, I don't
know how to do all of the cool and fancy things with access. But I am hoping
that I can find one of the other office programs to help me with this. Any
ideas?

 

[DL]

See if there is anything here to guide you
http://www.databaseanswers.org/data_models/index.htm

 

[Bob I]

If the "Customer" field of the record is empty, would not the box be
also empty or open? And so the obverse? Simply query you database for
the Customer name field being blank or not.