I have to import data in a custom table km_salesdataadminmacrosegment which has two lookup fields km_gebiet and km_country to a table km_salesdataadminareas. The relationship is Many-to-one and manual editing is working fine.
I try to import data from an excel file which has the following structure:
The values of km_gebiet and km_country are the unique identifier of the lookup table data.
During the import data" wizard I choose the option load into existing table.
But the lookup fields are missing in the mask for the column assignment and are therefore not imported.
What is the problem? Theoretically, it should work like this.
Thanks for any help,
Frank
