Good morning,
I have a table that contains three fields that I would like to
relate one to another, in other words, for example, when I go to the
form and I click on the drop down box for Buildings and select
Building1, when I go to the following field Floors, I would like to
only display the floor values that belong to Building1 so I can select
one of those. Once I have selected a Floor value for Building1, when I
jump on to the other field, Rooms, all I want to be able to display on
the drop down box are the room numbers that belong to the selected
Floor, which belongs to Building1.
Right now, when I go to these fields, regardless of my selection, I
get to display every value out there for all the Buildings, Floors and
Rooms.
How can I restrict Access to display Floors values depending on the
selected Building value and so on?
Thank you for your help.
Elvis V.