Beginner question about tables, fields, and relationships
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.