If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|