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

charles chang webman4@hotmail.com
Fri, 03 Nov 2000 07:05:01 PST

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 

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

Share information about yourself, create your own public profile at