I have database that has a many to many relationship and a non related table. I export each table to a seperate file.

When I try to import each file I can match the names on the main table, but I can't on the related and non-related tables. Why? The only thing I can select is add as new for the other table fields. This is a big problem, especially with duplication. I would love to only have to export to one file, but FM can't seperate the other tables. It wants to import only to one table.

Thanks for your help. If this has been discussed already please let me know.

Importing is layout dependent, meaning you first have to Go to Layout [one associated with the desired table] before specifying or performing each import.