Auto fill in forms, defined by previous choises

[jgaard]

Hi

I've been using Access for years for small home projects.
Now I need it to work smarter for me at work.

I have a database under construction.
I need it to keep track of some cable documentation and ultimately to enable printing of specialty labels. One set for cables using a Rhino6000 label printer and one set for documenting with a QR code.

My problem really is that I'm lacy.
I want drop down lists for most things.

So the basic structure of my DB is that I have a CI, a room, a rack and a switch.
Once I choose the room I only want to be able to choose certain racks.
Once I choose the rack I only want to be able to choose certain switches.

Also I need it to be fail safe, so that I don't ruin my documentation should I choose to add further rooms, racks or switches.

Is this possible?A

Once I have this working I'll be looking into the printers....

Kind Regards J;-)

 

[mrojas]

In the racks drop-down, make its RowSource equals to your CI "control source" and not to its row source. This is important, your dependent drop-down should draw data based on its parent's drop-down control source.
Make sure that the parent and child drop-downs have a related field; the child has CI as one of its fields that corresponds to its parent's CI.
Do the same for the next drop-down.

 

[jgaard]

In the racks drop-down, make its RowSource equals to your CI "control source" and not to its row source. This is important, your dependent drop-down should draw data based on its parent's drop-down control source.
Make sure that the parent and child drop-downs have a related field; the child has CI as one of its fields that corresponds to its parent's CI.
Do the same for the next drop-down.

OK, I'm not very much into Access in the terms that you are using, is there a guide on how to do this.