Problems importing data

[Aloha]

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

[Aloha]

Hello,

Nobody is out here, in this forum?

[comment]

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

[Aloha]

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

[comment]

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.