[ic] how to implement for an item that belongs to multiple categories?

["charles chang" <webman4@hotmail.com>]

Hi,
Does someone have better way to implement the following scenario?
For a database of movie titles, I currently have multiple fields for the 
actors.  That is, actor1, actor2, actor3, ..., actor10.
I want to search on each actor also.
This way limits to have only upto 10 actors per movie title.
I could add more fields, but it seems like there is a better way to handle 
this.

Thanks.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users