I work on a help desk and a lot of what we do is imaging and deploying new machines. These machines have numerous custom configurations that need to be made based on a variety of variables. I'd like to create a database where I enter the basic information (i.e. User name, machine model, permissions level, etc) and the database generates a checklist based on those parameters.
The difficulty is because, while most of the items on the to do list are simply "if Model-X then get line-item-Y", some of them are contingent on 2 or even 3 parameters being there. I can't think of a way to make a query that can get values based on combinations of OR and AND statements where the number of ANDs is also variable....does that make sense?