I have the arrays
EMP (EMP_ID(PK), Name, PROJ_ID(FK))
PROJECT (PROJ_ID(PK), name)
SALARY (SAL_ID(PK), date, amount, EMP_ID(FK))
I have done the appropriate relations and i want to take something like this:
wesuppose that EMP name is George and the project is storage
then i take something like this:
George storage 22/2/2007 $2000
George storage 2/2/2007 $3000
George storage 5/7/2007 $100
George storage 10/11/2007 $1200
but i want to take something like this:
George storage 22/2/2007 $2000
______________2/2/2007 $3000
______________5/7/2007 $100
______________10/7/2007 $1200
I'll appreciate any help...
thank you in advance...