Creating Many Relationships from One Parent Table

Question

Hi!&nbsp; So I am building an application where One Member may have many roles: professor, supervisor, donor, etc.&nbsp; I was wondering how to set this up so that by noting this in the "Members" table it will fill in or update the appropriate table it relates too.&nbsp; Is this possible?&nbsp;

archiveuser · Answer

I would have to see / know more about your application structure, but it sounds like you have multiple tables to manage similar items - people. If this is the case, I would ask why you feel this is necessary and encourage you to limit it to 1 table. If you simply need to see a different list of people in drop-downs, you can control that through reports without the need to have separate tables for Professors, Supervisors, Donors, etc. Even if you need to capture different information for each role.

Forum Discussion

Creating Many Relationships from One Parent Table

Related Content

Cross App Relationships

Totaling Child Records Live on Parent Form

Add child record through parent form and redirect back to parent form in edit mode

I need help creating a snapshot field in a unique parent-child relationship.

AI Smart Builder for Creating Apps and Streamlining Pipelines