Personally, I'm leery of giving specific advice on table design. What looks
good in a post, might not match your actual business rules. The
relationships between the tables are even more important than the table
designs themselves, and you haven't included any information about their
relationships here.

I suggest reading "What Is Normalization?" and working through some of the
tutorials he
http://www.rogersaccesslibrary.com/f...ts.asp?TID=238.

They give you a step-by-step rationale for database development, and you'll
know you've got them designed right.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Monet 138" wrote in message
...
We have a database for our valves & hydrants for which I'm attempting to
improve in many areas. One such area is the location field can contain a
lot
of different information such as Area/Town, Contract, Primary Street,
Secondary Street, County, Misc Info, RR-Xing, Stream-Xing. A lot of the
individual pieces of these records are common and show up on many records,
but needs to be displayed as a single string of text for reports.

Here is my guess on how it should be setup but I could really use some
advice if I'm going about this incorrectly or inefficiently.

tbl_Location: containing, ID, Misc Info, RR-Xing and Stream-Xing and links
to the following tables
tbl_Area: ID, Area
tbl_Contract: ID, Contract
tbl_Street (2 links): ID, Street
tbl_County: ID, County

Setup a form for the tbl_Location table using combo-boxes from other
tables
and text & check-boxes for the rest. Then create a column in the Valve &
Hydrant tables for location that creates a single text string
(concatenation)
of the various columns from tbl_Location.

Hope I explained that well enough. Thanks in advance for the help.

-- "Imagination is more important than Knowledge. Knowledge is limited,
Imagination encircles the world." ~Albert Einstein