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 table contains things like an order_id, the order_number, the customer, the selected address, etc.. The order_detail table contains the items that are on the order. On Sun, 25 Jul 2004 12:40:09 -0500, Robb Kerr <[EMAIL PROTECTED]> wrote: > 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 which records from > Interests the member has checked in their record of the Members table? > > Do you create a TEXT field in the Members table and save a comma-delimited > string of InterestsIDs? > > Thanx. > -- > Robb Kerr > Digital IGUANA > Helping Digital Artists Achieve their Dreams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
