I'm looking for advice on how to handle this. I have a members table. And I have a Committees table. A member may belong to one or more committees.
So I assume in the members table I need a committee ID field that stores the committee ID number that the member belongs to. But what if they belong to more than one committee? How can I handle the storage of multiple committee IDs?