Relationship-can't find file

[Art]

I'm stumped! I have three files "Attendance" "Stats" and "Addresses". They are all related to one another and are listed in the "File/Define/File References..." box. They are also all listed in the relationship dialog. The "Attendance" file gets a date and associated stats from the "Stats" file. Records are created for that specified date in the "Attendance" file for specified names in the "Addresses" file. So Attendance and Addresses are related by a field called "Household Code" and Attendance and Stats are related by a field called "Sundays Date".

My problem is that why everything looks good, it's not working right. Whenever I try to create records I get a dialog that tells me "Attendance.fp7 could not be opened. (Not Found)." It happens every time I click on the box in the relationship dialog that exists between the file Attendance and Addresses. So, I tell it where that file is, do my work, and close the files. The next time I open the files... boom! it happens again.

Any ideas why?

Art

[Art]

OK... never mind. I went to the "Addresses" file again and took a look at the relationship there (I'm also related to the "Attendance" file from the "Addresses" file. While it showed the complete path in the references box, I deleted it and redid it. Then I tried the other file and it worked. So... for whatever reason, the reference must have been messed up even though it looked like it wasn't.

Thanks