Can't rename files and re-create relationships

[slefevre]

For the past couple years, I've been helping a local film festival non-profit with the filemaker database that they use to track entrants. The original design was not optimal, because it had all the data run together for all years, when it needed to be separated by year. The number of the year also happens to be in the filename. So when each new year's festival has rollled around, I've helped them rename the files, re-create relationships, fix script references, etc.

 

The last Filemaker version I had worked with was 5.0, but I had been able to muddle through this process for 2011 and 2012. However this year, I've had difficulty doing it for 2013. I renamed the files and re-created the relationship on the graph, but when I tried to reference related files, I got the field widget displaying "unrelated table". I tried renaming the table, too, but that didn't seem to help.

 

I checked the version and it's 9.0v3, so I don't know if we were using an earlier version when we did this process in past years.

 

How can I get them a new set of files?

 

P.S. I tried to attach emptied fp7 files but the forum said I am not allowed to upload this kind of file

[doughemi]

Zip the files to post them on the forum.

[slefevre]

Awesome, thanks

FilmFestival.zip

[*susan*]

THe attached files had a number of "dead" external file sources and the table names started with numbers, which isn't really allowed.  To clean this up, I renamed the tables, the relationships, and then cleaned up the External Data Sources so that the files don't try to find files that are no longer available.

 

Check out the attached files. If I understood the issue, then this should work. Of course, if I didn't understand what you need/want then this isn't helpful.

 

All the best,

 

*susan*

 

file didn't upload...hmmm...

trying again.FilmFestival.zip