RE: More than one item with the same Item Code

["Thompson-Jordan" <Thompson-Jordan@mindspring.com>]

******    message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com>     ******

> ******    message to minivend-users from "Mr. Christopher F.
> Miller" <cfm@maine.com>     ******
>
> On Wed, May 26, 1999 at 06:16:21PM -0400, Cory J Trese wrote:
> > ******    message to minivend-users from Cory J Trese
> <digital@specialty-books.com>     ******
>
>
> Use a second table
>
> code       course
> ISBN1      econ 201
> ISBN1      econ 202
> ISBN1      econ 203

I would use a second "course" table like:

course	books
Econ 201	ISBN1,ISBN2
Econ 202	ISBN2,ISBN3,ISBN4
Econ 203	ISBN3,ISBN5

Then you could do course listing with sub-listing of the books for that
course under it. You can see an example of how this is done in the demo
using the "related" field to [loop] through the codes (in you case it
would be the books field).

Christopher Thompson

>
> And then join or do additional query.
>
> >
> > List :
> >
> > Is it possible to have a duplicate of an item in a database and have
> > the search engine display the appropriate data for each
> > individual entries?
> >
> > -Background
> >
> > Each item in my database is referenced with an ISBN (unique 10 digit
> > code for shipping and inventory use, as well as buying from
> > publishers.)
> >
> > We supply these books to students, and often times different classes
> > have the same book requirement (and thus the same ISBN) and I have
> > been forced to maintain a database with lots of "ECON 201/ECON 202/
> > ECON 203/Economies of the World 301" stuff in the "course" column.
> >
> > Is it possible to have more than one entry for an [item-code] and
> > have the results page display only the results that apply to the
> > search that the end user ran (searches are done by the "course" field
> > or by the "call" number of the course.)
> >
> > Am I trying to do something impossible?
> > ========================================
> > Cory Trese
> > email : digital@specialty-books.com
> > phone : (740) 594 - 2274, ext 223
> > phax : (740) 593 - 3045
> > ========================================
> > Mail Sent from
> >
> > Specialty Books,
> > Athens Ohio, 45701
> > www.specialty-books.com
> >
> > RedHat Linux
> > P][  /   2.0.36-07
> > ========================================
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.
> Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> > Archive of past messages:
http://www.minivend.com/minivend/minivend-list

--

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Database publishing, electronic commerce, office and internet integration.
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list