Showing results for 
Search instead for 
Do you mean 

Looking For Experienced Response on Yes/No Fields and Drop Down Fields

Bronze Contributor
Posts: 1,448
Country: USA

Looking For Experienced Response on Yes/No Fields and Drop Down Fields

This question is really for those consultants and expertes who have been using Yes/No and Drop Down fields.  I'm looking for an opinion of what you think is the better.


Here's my scenario:

I have about 100 customers.  Each customer has a company and on that tab I now have about 75 check boxes for characteristics about them broken into about 10 categories that all my customers could share.  For example, there could be up to 5 manufacturers of a type of equipment they have, so I check that manufacturer's box -- a customer could have more than one manufacturer represented .  I'm using that information when meeting with the manufacturers to either show they are a customer of the manufacturer or a prospect of the manufacturer.. 


I've added a drop downs for almost each category to catch characteristics that are not covered by a yes/no box.  I have also found that I'm using one drop down that is growing in length, and am not sure that is wise -- but I don't know why.


I'm running out of real estate on the "profile" tab, so now I'm thinking of moving entirely over to drop downs in each category.  I may have up to 10 yes/no boxes in a category but only 1 or 2 are checked. 


What I'm really asking, is what am I not thinking about?  Searches should be covered, right? 


Should I have just a few drop down lists or create a drop down for each category?


Will reporting be easier with multiple drop downs or just a few.drop downs. 


Well, my wife said this is very confusing, but she is not technical at all.  However, I am open to a response that "this doesn't make any sense".

John Purdy
ACT! Premium V. 18
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.