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

Jonathan Clark jonc@webmaint.net
Fri, 3 Nov 2000 15:22:11 -0000

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.


>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