---- [EMAIL PROTECTED] wrote: 

I already corrected my first e-mail.

> I am writing my first app with R-base.
> I could use a little help.
> 3 tables that direct the app:
> 
> Customer-
> custId (primary key)
> busId (primary key)
> custname (primary key)
> busname (primary key)
> (should 2 or all be primary key)
> 
> Project- 
> projname (primary key to 3rd table)
> projid (primary key to 3rd table)
> custId (foreign key to customer)
> busId (foreign key to customer)
> custname(foreign key to customer)
> busname(foreign key to customer)
> 
> Another table:
> projname (foreign key to project)
> projid (foreign key to project)
> custId (foreign key to customer)
> busId (foreign key to customer)
> custname(foreign key to customer)
> busname(foreign key to customer)
> 
> Then no other table would have a 
> primary or foriegn key.
> 
> Thank you.
> 


Reply via email to