Field Grouping

Example of a table called Customers:

Address1
Address2
CompanyName
City
FirstName
HomePhone
MobilePhone
LastName
State
WorkPhone
Zip

The challenge with the above list is that when you sort the field list in the table alphabetically Address1 and 2 are both on top while Zip is at the bottom of the list.  If the table structure is relatively small this is not a big deal.  If you have a lot of fields in the table then having your fields grouped together will save you the extra time of trying to find the fields you want.

An easy way to keep those together would be to change the names just slightly to something like this:

Address1
Address2
AddressCity
AddressState
AddressZip
NameCompany
NameFirst
NameLast
PhoneMobile
PhoneHome
PhoneWork

 Notice that you now have groups of Address, Phone and Names and when sorted it keep the like fields together.

Tagged with:
 

Comments are closed.



© MyDBSolutions, LLC. All Rights Reserved.