One to many relationships
C
Cor Schutte
There are situations with linker records where you would like one-to-many relationships. It seems like it only allows either one-to-one or many-to-many.
example - I want one customer to have many projects but I only want one customer per project. This does not seem to be possible at the moment.
Thanks
Brian Dollen
Cor Schutte This is actually currently possible. When you create a linked record, you're only ever choosing one-to-many or many-to-many. If you deselect the ability for it to link to multiple records, you'll see in the connected application's linked record settings that the multiple record option is still checked and can't be unchecked.
R
Rick DiChristofaro
Brian Dollen: Do you think there is another way to represent this in the UI? Currently, the one-to-many relationship seems implicit when creating the linked record field. I didn't know I could do this until I did further research in this feature request page. I could be wrong, but the "average" user might not understand this when first using the app.
It seems the relationship is many-to-many by default. Then you can choose to change the relationship on the origin app to one-to-many. And can toggle back and forth if need be. While the destination app will always remain as "many".
Fibery.io has a good UI when creating a linked relationship. It asks how the relationship should be structured in each direction. Could the UI options be changed or would that require reworking the underlying relationship logic? I attached a pic from Fibery that shows how relationships are created.
I'd like to hear your thoughts. Thanks