Each member can have several interests, and each interest can be held by
several members. The best way to do this is with a third table relating the
two:
CREATE TABLE member_interests
(member_id INT, interest_id INT,
UNIQUE INDEX mem_int_idx (member_id,interest_id);
Each row in this
Create a seperate table called member_interests or something similar
Store one member_id and one interest_id (or whatever you have your PKs
named) in each row.
This is similar to an order entry system, which typically has one
table for order_headers and one for order_detail. The order_header
tab
I have come across this problem a few times and wondered how other people
solved the problem.
Let's say I have a table containing Members. Each Member can choose several
items in which they are interested. Each of these items represent records
in a separate table - Interests. How do you store whic
