Re: Too many fields?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Tue, 5 Jun 2007 11:51:01 -0700, Tomtheappraiser
<Tomtheappraiser@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

My problem is that I do not understand relationships at all. I have tried
reading about them in the help section, but I just don't get it.

Check out some of the references at these websites, particularly the "Database
Design 101" links on Jeff's site.

You're making a very common beginner's mistake - "Committing Spread*** Upon
a Database". If you're assuming that you need to put all the information into
one record in one table, that assumption IS WRONG and is the source of your
problems! "Fields are expensive, records are cheap". You'll need multiple
tables, and each property will have zero, one, or many records in some tables.
RBear3 has given you an excellent starting point!

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html


John W. Vinson [MVP]

.

Quantcast