Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
● cView
● Report Analyzer
● cViewSERVER
● ReCrystallize

Crystal Reports: Free trial
Articles:
● Administration
● Advanced
● Basic
● Crystal eNL
● Database
● Financial
● Problems Solved

 Books:
● CR Books
● Database Books
● Developer Books
Tools:
● All CR Tools
● CR Analyzers
● CR Bestsellers
● DataBase Tools
● CR Graphics
● International
● CR Mail UFLs
● ReCrystallizePro
● CR Schedulers
● CR UFLs
● CR Viewers

Add'l:
● About us
● Contact Us
● cViewSUITE Ppt
● Support

Crystal Reports
on Steroids

Database Tips: Use The Singularity Principle

Use each field of a database for one purpose and only one purpose. Do not use one field for several different things.

Sometimes, a field has been used some of the time for one purpose and is then shanghaied into another duty. Avoid this. Create a separate field for each role. Then there is no confusion about what a specific field is used for.

 

 

 

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.

These keywords may have brought you here: singularity principle, using database fields, designating fields, assigning fields, database tutorials, database articles, access, oracle, sql, mysql, database tips, database error prevention, database optimization, database design rules.