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

[Jonathan Clark]

Why not just use one field with the actors separated by commas? Maximum
number for a movie would be limited just by the field size.

Searches on this would work ok.

Jonathan.
Webmaint.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.
>