You need to sign in to do that
Don't have an account?
Ross.ax1563
Lookup to Pricebook
Hi All
Winter '14 brought the ability to create a lookup relationship to the Pricebook Object. I am trying to do this but am getting the following error (I specifially pick lookup and NOT master-detail):-
You cannot create a new Master-Detail relationship on an existing custom object if records already exist. You must first create a Lookup relationship, populate the lookup field with data in all records, and then change the relationship type to Master-Detail "
Any help!?
Thanks
Ross
Ross,
I just tried this, and had no trouble with the first one. So I tried the second one, and this time I made the field Required - then I got the error you describe. The field can't be Required and you can't select 'Don't allow deletion of the lookup record that's part of a lookup relationship.' You must select 'Clear the value of this field. You can't choose this option if you make this field required.'
If this helps, please mark it as a solution, and give kudos (click on the star) if you think I deserve them. Thanks!
-Glyn Anderson
Certified Salesforce Developer | Certified Salesforce Administrator
All Answers
I tried the same and working fine for me. I tried on Account object and I guess because of that there were no option to select 'Master-Detail Relationship' in data type. On which object you are trying to create this?
Ross,
I just tried this, and had no trouble with the first one. So I tried the second one, and this time I made the field Required - then I got the error you describe. The field can't be Required and you can't select 'Don't allow deletion of the lookup record that's part of a lookup relationship.' You must select 'Clear the value of this field. You can't choose this option if you make this field required.'
If this helps, please mark it as a solution, and give kudos (click on the star) if you think I deserve them. Thanks!
-Glyn Anderson
Certified Salesforce Developer | Certified Salesforce Administrator