Hi All,

Sorry, I still need some help with this...I can't for the life of me
figure out how to do this:

I need to use the field InvoiceNumber (the primary key) on a form in an
Append Query that copies data from one table to another so it can be
called in a subform. I can get the Append query to work with the
exception of inserting the InvoiceNumber into the appended data, which
is important because the subform should only pull data for that
particular InvoiceNumber.

I know it can be done, I just can't figure out how to do it.

Thanks,
Mike