Re: Table schema

On Sun, 23 Mar 2008 20:34:17 -0800, Eric Kaplan
<tobycraftse@xxxxxxxxx> 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
.