Skip to main content
Question

Creating Many Relationships from One Parent Table

  • August 7, 2019
  • 0 replies
  • 25 views
Hi!  So I am building an application where One Member may have many roles: professor, supervisor, donor, etc.  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.  Is this possible? 
    This topic has been closed for replies.

    • ArchiveUser
    • Registered
    • August 8, 2019
    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.
    Terms & ConditionsAccessibility statement