Forum Discussion

MalloryOxendine's avatar
MalloryOxendine
Qrew Trainee
6 years ago

Creating Many Relationships from One Parent Table

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 my noting this in the "Members" table it will fill in or update the appropriate table it relates too.  Is this possible? 
Relationships
Tables and fields
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    Are you planning on using this role selection to customize the selection of a Member in another table?  For example, if you are adding a record are you selecting "Donor" and then want a list of only-Donors from your members list to display for selection?
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    We should be clear on whether you want to "display" the different roles that a member has in connected tables (relationship lookup fields) or whether you actually need a multi-table structure that will allow conditional relationship selections based on something else.  Perhaps it might be better to give me a call so I can offer you the best advice for your situation.

    I actually have to leave, but you can contact me in the morning at (626) 771 0454 if that helps you.
  • MalloryOxendine's avatar
    MalloryOxendine
    Qrew Trainee
    6 years ago
    Yes I can give you a call! What is your number?

    Essentially, I have my member table that will record every individual. 

    I want separate tables for (1) Professors, (2) Supervisors, (3) Donors, (4) Professors in Training 
    I want to be able to connect the different tables so that when one member is a professor & supervisor the same fields are translated over for me to the appropriate tables.  

    Does that make sense?