[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: More than one item with the same Item Code
****** 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
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
