Hi to all. Perhaps it's a stupid question but I spent nearly the whole night to get rid of it. Here's the trouble: - have three tables in the same file: Addresses, int_codes and italian_zip_ci

Hi to all.

Perhaps it's a stupid question but I spent nearly the whole night to get rid of it.

Here's the trouble:

- have three tables in the same file: Addresses, int_codes and italian_zip_city;

- in the input format I have a value list made from state_name and state_code coming from the int_codes-table which I use to update the same fields in Addresses and this is OK;

- I want to use the updated int_codes in Addresses to have a value list from the italian_zip_city.

I have set up the following relations:

- between Addresses and int_codes through state_name;

- between Addresses and italian_zip_city through state_code saying to use only related records: DOES NOT WORK.

Furthermore, how can I tell to add a record in int_codes and italian_zip_city if I enter a new value in the relation-field of Addresses format?

What does the option "sort starting from this table." mean?

Great thanks in advance to any suggestion.