You need to sign in to do that
Don't have an account?
Changing Junction Object name
I have a junction object with 2 master detail relationships, one to contacts and another one to a custom object named program. I currently have 2 fields, the contact field and the porgram field. I am using workforce rules to avoid duplicates. What I want to know is that, apparently the junction object has to have a name, whether filled manually or numeric.
Is there a way that when i choose the contact and the program, autofill the name with a default value? Problem is, when a duplicate is created, it says "the following duplicate already exists: 12" . If I let the user fill out a random name and then set a field update to change the name, it just feels wrong.
Hello Ricardo,
I understand that you wish to auto fill the field values without duplicates. You may use the data type Autonumber for these fields. Auto number automatically assigns a unique number to each record. The maximum length of any auto-number field is 30 characters, 20 of which are reserved for prefix or suffix text.
Please let me know if i misunderstood your requirement.
No, I have 3 fields in my page. The contact lookup field, the program lookup field, and the Name. I want to avoid to set the name to an autonumeric value. So I want that when both the contact and the program are selected, the Name will fill before insert.
Ok, so what should be in the Name field, is it the contact name? If so then create a formula field "Name" on junction object with return type text which will have the value of the contact name field.