Create new record from related table by comparing the two tables

[Toni]

Hello

I have two related tables in the same file.

In table Product I have a field A and in table Feature I have a field A1.

The Field A contains a code of the product and thanks to the relation it gets

its features from the table Feature. There could be from hundred to thousands

records in the table Product which does have the same value in the field A.

But in the Table Feature there is only one record with the value in A1, and

it is restricted to have a unique value by definition.

My question is, is it possible to create a new record in the Table Feature, when

in the table Product is imported a record with new value in field A which does not exist

in table Product as well?

Thank you, Toni

[Ocean West]

Toni,

An imported process will only import data into the target Table. In order to get data into another table you may need to either create a looping script

and set a field in thru the relationship to create the desired related record. -

OR you could perform another IMPORT into the other table with some validation turned on only the records that pass validation would be imported.

Stephen