List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 7 2000 2:27pm
Subject:Re: A Tale of Three Tables
View as plain text  
At 10:20 AM -0400 04-07-2000, Margie Wiers wrote:
>Yes, okay, thanks.
>
>So, the master table is populated at the same time as the member and college
>tables from user input?

That would be one way to do it.  Another way would be to construct
your lists of people and collleges, then later generate entries for
the master table.

>   Then, let's see, the primary key would be the
>combination both member_id and college_id and the combination of these two
>would make it unique?

Assuming you want unique entries in the master table (which you probably
do), yes.


-- 
Paul DuBois, paul@stripped
Thread
A Tale of Three TablesMargie Wiers7 Apr
  • Re: A Tale of Three TablesPaul DuBois7 Apr
  • Re: A Tale of Three TablesMargie Wiers7 Apr
    • Re: A Tale of Three TablesPaul DuBois7 Apr
  • Re: A Tale of Three TablesMargie Wiers7 Apr
    • Re: A Tale of Three TablesPaul DuBois7 Apr
  • Re: A Tale of Three TablesMargie Wiers7 Apr
  • Re: A Tale of Three TablesMargie Wiers7 Apr