On Feb 10, 12:05*pm, Daryl S wrote:
Frank -

You want to add the new Training record that is on the form - the one with
the new training course - you don't want to insert records for all the other
training courses (they already are in the table).

--
Daryl S



"Frank" wrote:
Daryl,

TAINING table does not have primary key and other unique keys. It can
have multipe records for employee_id. I do know why the second
criterial should be EQUAL TO instead of .

Thanks

Frank
.- Hide quoted text -

- Show quoted text -

Yes, It's correct. When I used "" in criterial, not record can add
to the table becouase there is no such record in the table . When I
used "=", all data for the employee were added into the table. It
seems the append query won't work at all. is there any other way to
add (insert) record on the form into the source table.


Thanks
Frank