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 (foriegn key to custober) busId (foriegn key to custober) custname(foriegn key to custober) busname(foriegn key to custober) Another table: projname (foriegn key to project) projid (foriegn key to project) custId (foriegn key to custober) busId (foriegn key to custober) custname(foriegn key to custober) busname(foriegn key to custober) Then no other form or table would have a primary or foriegn key. Thank you.
