AnsweredAssumed Answered

Beginner question about tables, fields, and relationships

Question asked by RichardDetwiler on Dec 29, 2013
Latest reply on Dec 29, 2013 by JennySemmler

Title

Beginner question about tables, fields, and relationships

Post

     I'm beginning to learn to use FMPro to keep track of records for a voluntary association of foreign language teachers.  Teachers' names and other personal information will be in a Teachers table.  I need to keep track of what languages teachers teach.  Most teachers teach only one language, but some teach two.  How best should I handle this.  Language1 and Language2 fields in the Teacher table?  A separate Languages table and a join table between the Languages and Teachers tables?  Something else?  And how to view the languages on the Teacher info. screen and how to sort Teachers by language...

     Thanks for any help and advice.

     Richard Detwiler

      

Outcomes