multiple catagories for 1 member

[Rip West]

I have a simple address table, with first name, last name, addresses, etc. I
would like to add a catagory field for each member's interests. A member
could have multiple interests. Say I have Catagory 1 - Book Club, catagory
2 - bridge group, catagory 3 Christmas card list. How do I enter a number
in the catagory field that would show that a person is a member say of
Catagory 1 and Catagory 3. I was thinking back to my old basic programing
days when you could use the or function. Or is there a much simpler way to
accomplish this?

 

[scubadiver]

Each member has many interests. Create a new table and a 1-to-many
relationship.

 

[Douglas J. Steele]

Actually, it would be a many-to-many relationship between members and
interests. Each member can have 1 or more interests, each interest can be
shared by 1 or more members. That means you need 3 tables: a Members table,
an Interests table, and an intersection entity to resolve the many-to-many.
The third table need only have the MemberId and InterestID fields in it.