Subfields

Basic design is a table with (Phrase, Category) as the compound primary key
(unique and required). What are you really working on? I spent seven months
fixing databases where added columns until they were blue in the face. One
word of advice. Information belongs IN the table (in a column, as a value),
not ON it (as a column name).

Trust me, adding columns for each category name will cause you no end of
problems. I know, I met them every day. Simple things like does a cell with
no data in it mean a *missing* value, or that the condition does not exist?
There is a substantial difference.

If you want to create something like below, you can create a crosstab query...


I am working with data that seem to require subfields. I am using Access 07.
I am analyzing features of instances of phrases I search in the Internet:

Phrase Category 1 Cat 2 Cat 3
A 5 / 50% 5 / 50% 0
X2, Y3 Z5

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200909/1