Re: Create list question

["David T. Jones" <djones@xxxxxxxxxx>]

At 02:39 PM 1/10/00 -0600, Patricia Thompson wrote:
>Does anyone know how I would create a list of bib records that have more
>than one order record attached?

Don't know if anyone has answered this offlist, but the short answer is
that you can't. The long answer is that you could export the bib and order
record numbers from a bib review file and manipulate the output to produce
a spreadsheet like format with a macro language of your choice. Or, you can
just glance through the list! Such a list might look like this as output:

RECORD # = b1670146x. RECORD # = o2099330. 

RECORD # = b16701471. RECORD # = o2099342. 

RECORD # = b16701537. RECORD # = o208644x. RECORD # = o208725x. 

RECORD # = b16701550. RECORD # = o2014981. 

RECORD # = b16701781. RECORD # = o2099366. 

RECORD # = b16703364. RECORD # = o2100575. RECORD # = o2100599. 

One thing to keep in mind, though, is that if you have multiple accounting
units, the innopac will not export the numbers for the other units order
records. If this is your situation, you would have to export lists from
both accounting units and then reconcile them in a database or spreadsheet.

>From a relational database standpoint, this is a no-brainer, but the
innopac is not a true relational database...

HTH,




=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
David Jones                          mailto:djones@xxxxxxxxxx
Library Systems Manager III          phone: 408-551-7167
Orradre Library                      fax:   408-551-1805
Santa Clara University               http://www.scu.edu/library/
500 El Camino Real                   
Santa Clara CA 95053-0500            "Insert pithy quote here"