append data to record and subrecord.

M

Mario

Hi there ,
I already posted this question in the Modulescoding newsgroup , but maybe in
this newsgroup you can also help me.
Hopefully i'll explain it correctly.

I receive a file with orders form a customer.
It contains a collectdate , reference nbr , company , address , etc...
for this i created 2 tables :
- main table with all data : ref-nbr , company ,address , etc... ( but
not the collectdate.)
- subtable (status) with collectdate , problemcode , comments , etc...

I import the data from the file received into a table called TblImport

I need to do the following :
1) import the data without the collectdate into the maintable ( which is
not a problem - i create an APPEND query)
2) import the collectdate from the TblImport and append it in the
sub-table , but it should match the reference number in the main-table.

Do you have any idea how to do this ?

Thanks
Mario
 
Top