J
Jacinda A
I am using Access2003
I am trying to set up an append query that will combine similar fields from
two tables onto one.
ex: FName, LName from Table A
FName, LName from Table B
dump into FName, LName on Table C
This is for a human resources type of database... Table A being the employee
and Table B being the dependents.
Table C would represent everyone from those two lists who let's say have
elected health insurance... so the employee from Table A that person's
dependents from Table B... all together in a single list on Table C...
I tried two separate append tables, and I am getting that key violation
error... can someone enlighten me...
I am trying to set up an append query that will combine similar fields from
two tables onto one.
ex: FName, LName from Table A
FName, LName from Table B
dump into FName, LName on Table C
This is for a human resources type of database... Table A being the employee
and Table B being the dependents.
Table C would represent everyone from those two lists who let's say have
elected health insurance... so the employee from Table A that person's
dependents from Table B... all together in a single list on Table C...
I tried two separate append tables, and I am getting that key violation
error... can someone enlighten me...