United Geeks and OCD

Well, someone actually volunteered to help with the Lexicon project so I have to shift gears into database and tables development mode.

Anyone with some previous OpenOffice Suite Base databases - just a few fields with at least three lookup tables - your help is also needed.

The design is simple. The basic design would have a few up-front field, with three (so far) look-up tables.

• RECORD NUMBER - with scribe id and file numbers - bookkeeping for reference at some later date. (10 Char max.)
• WORD (20 Char max.?)
• PRONUNCIATION KEY (20 Char Max.)
• DEFINITION - 150 characters Max. (?), anything beyond goes into Notes. Or it needs to be a basic flexible field. Is that even possible?
• LANGUAGE/CULTURE (look-up table) - Tongue, or Racial group, or Nation - 20 Chars.
• SOURCE (BOOK or FANZINE that is the origin - look-up table) - 1st Ed, 2nd/3rd Ed, Fanzines/Webzine, Newsletters/Columns
• CLASSIFICATION - Item, Geographic (Jorunographic?), Isho, Earth-Tec, Personality, Historic. (another lookup table eight or nine classifications)
• NOTE - anything that needs elaboration, such as a Colonial tongue, but it has to be specified as Thanterian/House Adwa or some such. I hope this can be just a flexible field.

I already have the look up tables for Language/Culture and Source, am deciding on classification but do not think that will take all that long.

That will then allow reports to be extracted for Shanthic, Isho-related, specific countries, historical personalities, wars ... whatever kind of report is needed. And will appeal to people who just want to soak in the Jorune word pool.

So I need additional scribes to pull the words (don't want the new guy to get lonely), and now I need help with the database design.

I used to work in dBase ][, but that was in the early 1980s. My last database was 1982.

And things have changed.