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 ...
Relationships
Tables and fields
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?
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
(626) 771 0454