Use Component Descriptions

by Pat Cummings » Wed Jul 15, 2009 8:06 am

Component descriptions automatically combine data from many fields into one combined description at output. This creates consistency, the ability to validate data entry, and ability to query.

When you have complicated material descriptions in your reports...

description.jpg (32.53 KiB) Viewed 100 times

...instead of a single, freeform Description field for your soil lithology data that looks like this...

blob lithology table.jpg (65.63 KiB) Viewed 100 times can break the description into separate fields:

component lithology table.jpg (76.91 KiB) Viewed 100 times

The latter method uses component descriptions. They can consist of as few as three or four fields or as many as 35 or more. You can also setup your database with one table for Soil Descriptions and another table for Rock Descriptions. Component descriptions are not limited to just soil and rock descriptions; you can also setup multiple fields for Sample data, or any other application where consistency and searchability are needed.

The advantages of component descriptions are:

See Also