On Sun, 23 Mar 2008 20:34:17 -0800, Eric Kaplan
<tobycraftse@[EMAIL PROTECTED]
> wrote, quoted or indirectly quoted someone who
said :
>crew -> programID -> member
your main table would have three fields, plus extra info about
members.
crewid : programid: memberid:
you would also have a table with info about crews indexed by crewid
and crew name
You would also have a table of info about programs indexed by program
name and program id.
If you had just a small database, you might dispense with crewids and
programids and just use the names as keys.
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com
|
