AnsweredAssumed Answered

Relationships from Same Table

Question asked by tm9 on Sep 1, 2013
Latest reply on Sep 3, 2013 by keywords

I have a table for organizations and two tables for members. One for members and one for new members. Is it more effieicent for a larger database to have the two tables for the different types of members or to just have one table for members with a type field?

 

If I were to use one table for members how would I set up a join table so I coud assign members to new members (ie: as an advisor or mentor)?

 

Thanks,

Outcomes