HELP!!

I am trying to create a relationship from one file to another but for some reason, after I have created the Relationship Name and located the file and selected the match fields, the relationship is not confirmed and I get "File Missing" in both the Relationship & Related File columns in the Define Relationships box.

The match fields are "Calc/Text" in the Parent File and "Text"in the Child File.

I have 25 current relationships set up.

Both files are on a network and I have created other relationships in other files as a test and these seem to work.

Have I reached the maximum or is it something more sinister??

What you did should be okay, so it sounds like something more sinister.

The only thing I can think of is that I recall some versions of FM having problems with long path names on some versions of Windows. Maybe try again with your files only one subdirectory deep on the disk.

Also, make sure you have the latest update of FM 5.

Dear Bob

Thanks for your comments. I'll check out the updates.