Jump to content

Relation Error


Effie
 Share

This topic is 6509 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6509 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.