I have two simple files that were converted from Filemaker 7 to 8. One relates to the other via a single field, and to itself via a Self-Join for Find Duplicates.

I am trying to adapt these two files to a slightly different purpose by changing their names, table names, file relationships and updating the relationship accordingly.

I have tried several different ways of doing this short of recreating new database files, but cannot get around a Table Missing error in all fields of the database holding the relationship. Recreating the relationship does not solve the problem. I have checked and rechecked without finding an error.

I have a sense that the problem lies with my creating a second table name by copying and then pasting in order to rename the table, since ALL fieldnames then come up with Table Missing. This happens even when I delete all file refs and calculations and relationships!

Any suggestions appreciated!

Thanks!

You need to change the file references, not the table names.

This is where FMP Advanced (developer) comes in handy, it has a tool for renaming files and updating file reverences automatically.