Add In Simple One To Many Functionality

[JesseAppEnthusiast]

It would be awesome if there could be all relationship types i.e.: One To Many available as well where we can mimic the subgrid type relationship. I understand we can mimic this type of function in a custom relationship type by providing two tables and relating the current table with the intersecting table (Relationship 1) and displaying the records of the linked table (Relationship 2).

Suggest Solution/Expectation If we provide "Custom" as the relationship type and only provide the relationship name value to the Relationship 1 only (one Student to many enrollments) and do not provide a value for the Relationship 2. When I select the component, I should be able to select from existing enrollments that I can associate to the current record. When I select an enrollment, it associates with the current record. When I select the "X" button, instead of it disassociating and deleting the enrollment record, it would instead just disassociate the record, not delete it entirely (current custom relationship type where when we select the "X" button, it deletes the intersect table record which is not ideal especially when done accidentally.) If the enrollment record does not exist, then we create a new one with quick create form, and the create form should open up the for the relationship 1 table. Then we would be able to select from existing enrollments and associate to the current record. When Alternatively add in a new relationship type option as "OneToMany" with the above functionality. Possibly an option to either simply disassociate from the current table or delete the record entirely if the "X" option is selected?

[khoait]

@JesseAppEnthusiast thanks for your ideas! I'll look into it.