Maximizing Connectivity & Productivity

Don’t use Yes/No fields to store preferences

This is an article by Allen Browne, about the use of creating a list of choices to select from, rather than creating seperate fields that are boolean (Yes/No) fields.

Using choice fields, preferably choices laid out in a seperate table, rather than a list of values in the field,  enable better reporting because of easier joins in the queries.

http://allenbrowne.com/casu-23.html

 

Leave a Reply

You must be logged in to post a comment.

E-mail: info@netlogistix.com
Mississauga, ON, Canada 905.607.3500