I am trying to establish a relationship between two files. In the first file, I have names and addresses of physicians offices. In the second file I set up a relationship to the first file using the physician name field. My goal was to have a pop-up list of all the physicians for selection. When I get to this physician name field, I do see the pop-up list, but when I select a physician name, I see an error message "The field cannot be modified until "physician name" is given a valid value. What am I doing wrong?

Version: v5.x

Platform: Windows 2000

You should never use modifiable data fields for relations. Your offices file should have an auto-entered serial number (or text) field, which is related to a corresponding field in the physicians file. Now when you select a physician's name from the related file, it will automatically create the record using the office serial number.