for this you need to use a linking table in order to create a many to many relationship:
members:
memberID - Primary Key
memberName
etc....
categories:
categoryID - Primary Key
categoryName
etc....
memberCategories:
memberCategoryID- primary Key
memberCategoryMemeberID - relates to members.memberID
memberCategoryCategoryID - relates to categories.categoryID
you would need to use the manage relational table behavior in data assist to manage the linking table.
Andrew reed posted a good guide for the manage relational table behavior in this thread:
showpost.php?p=84393&postcount=17