I have a database for our Scholarship and within it there are four databases that talk to each other; Student, Donor, Scholarships and Dinner. We have a different database for each Fiscal year. I copied the FY04 database into an FY05 database and everything was fine, for a while. Then out of the blue it started communicating with the Fy04 database, when it wasn't open. So I went in to define the relationships and I saw that it was relating to FY04. I can only assume this was happening because when you copy a database you copy all of it's values and relationships? So I went in and changed the relationships to FY05 and now it will not share the information at all. So each database holds the correct information but it will not communicate it in to each other. I am not sure why this is happening.

This is because you need to use the developer tool to rename a file and the "internal links" just renaming a file from your desktop or finder will not change the relationships, scripts, or other links within the file.

Can you be more specific? I am a very new user and I do not know what the developer tool is. I do not know where else to go to give value to my relationships. When I went into it the relationship names that it had were not ones that I was familiar with and I didn't know where the relationship names came from.

Does that make sense? Please excuse my simple attempt I am really finding these things out by trial and error.

You're trying to solve the wrong problem. You definitely do NOT want to create diferent database for each year. The year should be a field that is part of the record.