Re: Create list question

[pthompso@xxxxxxxxxx (Patricia Thompson)]

Thanks for your help!  No one else sent me an answer.  I think your
solution will work for me. 
Pat Thompson


>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"
>
>
>