[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] how to implement for an item that belongs to multiple categories?
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.
>
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
