On Thu, 12 Apr 2001, Dennis Gearon wrote:
> Date: Thu, 12 Apr 2001 15:16:42 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: relationship/field design
>
> I have a table design question, looking for tips, not the exact sql to
> cre
On Thu, Apr 12, 2001 at 03:16:42PM -0700, Dennis Gearon wrote:
> The biggest problem seems to be structuring the tables to force the
> requirement for at least ONE email address, but not having to create
> lots of empty fields.
Looks like you're looking for foreign keys, but you can't do that in
I have a table design question, looking for tips, not the exact sql to
create the tables.
I have tried several solutions, and as yet, I don't like what I am
coming up with. So if someone could help me, I would be grateful.
Assumptions:
's have several types, defined by a separate table: