Multi tiered conditional lists
First, I'm using FileMaker because it's a lot more user friendly than access and I'm not a DB guy. so I may be thinking about this all wrong.
I'm making a software inventory db for my department. it will have all the standard pertinent Software Fields in one Table, and then where we have installed the software, and the "where it's installed" is where I'm having problems.
I want to have a drop down menu from a "building" table (I did this part)
then have a second drop down menu with "Room Numbers"
and then have a check box list of the "client"
Lastly, I'm going to need multiple copies (I'm thinking 4 will do it) because the same software entry will be installed in different rooms and possibly buildings.
I fully aware that I may not be articulating everything perfectly so I've linked to the db with enough information in the the related tables.
Thank you for any help you can give me.