You need to sign in to do that
Don't have an account?
Creating Master/child relationship
Hello,
I want to create a master child relationship but I would like to do this off of the
Custom Fields & Relationships rather than the Standard Fields is this possible.
The way that I have set up my tables and objects are:
Questions (as a table)
Answers ( as a table)
It would be great to link the two via pick list such as
Question Tab
Question Number
1
2
3
Answer Tab
Question Number
1
2
3
This really doesnt seem possible. It appears if i want something like this: It would be more like the Question Tab: Question Number Standard field as either auto num or text
Then select the Question Number Standard as the corresponding one i want to answer
I would rather link the two tables via pick list - less user errors.
I'm not sure 2 objects is necessary given what you've described. Have you considered storing questions and answers on the same object? That would make it easy to set up a controlling/dependent picklist.
You can create the master-child relationship on the custom object as well.
Mater-detail relationship fields are always required on detail records.
To me its seems on-to one relationship the way you are modeling your data design not something that may require any picklist.