AnsweredAssumed Answered

Portal Question?

Question asked by snkm on Feb 22, 2009
Latest reply on Feb 23, 2009 by disabled_menno

Title

Portal Question?

Post

I have a relational database connecting one employee to several projects.  How do I also connect one project to several employees?

 

Currently I have the following:

 

EMPLOYEE_ID:  001  NAME:  Mr. Smith

--------------------------------------------------

PORTAL

--------------------------------------------------

PROJECT_ID:  001    DESCRIPTION:  Doing laundry

PROJECT_ID:  002    DESCRIPTION:  Eating lunch

PROJECT_ID:  003    DESCRIPTION:  Cleaning Dishes

--------------------------------------------------

 

I need to also have the following:

PROJECT_ID:  001    DESCRIPTION:  Doing laundry

--------------------------------------------------

PORTAL

--------------------------------------------------

EMPLOYEE_ID:  001  NAME:  Mr. Smith

EMPLOYEE_ID:  001  NAME:  Mr. Stevens

EMPLOYEE_ID:  001  NAME:  Mrs. Anderson

 

 

Outcomes