Bj,
Got it! I am sure you have given a similar explanation to someone
else not so long ago. The thing that hadn't quite connected is
entering an item to be classified more than once into a table. That
will do exactly what I want, which is to be able to list and/or count
all poems of a partic
- Original Message -
From: "Joseph, Smile Poet"
> Classification tables:
> a number with the simple structure:
> LIMERICK Lim_id, poem_id
> HAIKU haiku_id, poem_id
Let's have a quick run through relational databases shall we? You have a
bunch of poem classifications. Each can match many
Rudy,
Thank you for the comments and advice; the classification tables
could see one poem on several tables. A Limerick could be a science
poem and a Dotty Ditty, all at the same time
I think the string in string theory
Must be feeling pretty weary
For dimensions, eleven
(Including heaven?),
L
> Mainly I think to Rudy for kind comment.
a quick and free review, worth every penny:
> Main table:
> POEMS Poem_id, title, date_written, date_update[NULL]
good
> Classification tables:
> a number with the simple structure:
> LIMERICK Lim_id, poem_id
> HAIKU haiku_id, poem_id
no, just one