Newbies Mim Posted March 28, 2001 Newbies Share Posted March 28, 2001 I have created two databases - one customer dbase, the other contact dbase. I have defined their relationship. On the contact dbase I would like to have the "company" field use the values in the Company dbase. I thought I did everything correctly by defining the relationship and defining the values. The company names do appear in a pop-up list, but I am unable to select one. If I try, the error message "This field cannot be modified until "Company" is given a valid value" appears. Any suggestions? Thanks, Mimnull Link to comment Share on other sites More sharing options...
LiveOak Posted March 29, 2001 Share Posted March 29, 2001 You have probably created a circular reference. You don't need a relationship to use a value list from another file. Try the third radio button, "use value list from another file". Also, I would not use Company Name as the key field in a relationship, us a company ID number. -bd Link to comment Share on other sites More sharing options...
Newbies Mim Posted March 29, 2001 Author Newbies Share Posted March 29, 2001 Thank you for your help. It is now working. Mim Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8450 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 accountSign in
Already have an account? Sign in here.
Sign In Now