HI All,

I need help trying to accomplish the following:

I have three tables: tblClients, tblWork Descriptions, and
tblClientWorkDescriptions. I'm trying to use an append query to add the
records in tblWork Descriptions to tblClientWorkDescriptions while
adding the field ClientNumber (from tblClients), which is currently
being viewed on frmClient.

frmClients shows the clients records from tblClients as well as
tblClientWorkDescriptions in a subform, so it's important that the
Append Query adds the ClientNumber so the records for that particular
client can be viewed, edited and saved.

Can anyone help with this?

Thanks,
Mike