Hi,

I need Your help!

I join two files: import - source and import - destination.

In the source file I have a ceratin number of sets containing a name and dates corresponding to numbers, in a maximum of 12 lines and individual fields.

To make the managing more easy I have created a new file, with 2 tables, one containing the name and other data of a person and on an external table, the dates and amounts in one and only field for all the dates and one for the amounts. I have linked both table by a common ID field.

In the source file I have also created an ID field and attributed a serial number to each data set.

When I import the personal data, no problem, but I don't succeed in importing the data, one amount and date at a time, making the ID field of both fiiles corresponding

How do I have to proceed?

Regards

Aloha

Import.zip

Hello,

Nobody is out here, in this forum?

You need to make a series of imports into the Finances table, each time importing the ID and one pair of Date and Montant.

Thanks for the answer but that method doesn't work: every new import replaces of the previous one in the fileds date and montant.

Aloha

every new import replaces of the previous one in the fileds date and montant.

No, it doesn't - unless you set your import to update instead of add new records. Note, however, that at the end of each import, only the imported records are in the found set; you need to do Show All Records to see the previously imported ones.