AnsweredAssumed Answered

Multi tiered conditional lists

Question asked by TravisMolleck on Nov 21, 2011
Latest reply on Nov 29, 2011 by philmodjunk

Title

Multi tiered conditional lists

Post

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. 

Database

Thank you for any help you can give me.

Outcomes