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

Steve & Patti Getzinger steveandpatti@wubs.org
Fri, 03 Nov 2000 10:21:46 -0600

Maybe I am missing it by why not one field with all actors , separated in it?
Search will pull out all movies showing that actor. Regardless of what else is
in that field. Example:

in the field description I have dogwood trees are blue

If I do a search for blue it comes up, if I do a search for trees it comes up
and so on.
If I do not want the description displayed but want corresponding fields I
simply do not display description field on the results page.


charles chang wrote:

> 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

  WDI                          Steve & Patti Getzinger
  702 Lincolnway West          steveandpatti@wubs.org
  South Bend, IN  46616        http://www.wubs.org/
  219-287-4700 (Main Office)   317-535-0239 (Direct Line)