Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Wed, 14 Nov 2007 11:55:12 -0800 |
Content-Type: | multipart/alternative |
Parts/Attachments: |
|
|
Hello all,
My name is David and I'm the DBA for the Museum of Contemporary Art in
Los Angeles, California. I have inherited the TMS system from the
registrar's department. We are currently running 9.20 on SQL Server
2000. As soon as the guys at Gallery Systems get back to me with
upgrade instructions we will be moving to 9.35 on SQL 2005.
My question has to do with generating a shipping report for the
registrars. I have the table structures from TMS but I am having
problems getting the joins done in such a way that they are all one to
one relationships. My understanding is that for the report to run from
TMS the joins need to be one to one. I've had some email conversations
with the guys in support (Dimitry and Brian) but so far we haven't been
able to come up with any sort of solution. I'm reaching out to all of
you in hopes that someone out there has already slain this particular
dragon.
I need the following fields...
ObjectNumber
Lender (Constituent first and last name)
Title
Medium
Crate Number
Crate Dimensions
Crate Weight
Value
ShipFrom Geo & Address
ShipTo Geo & Address
I know where all of the fields are. I have joined the tables together
but I get multiple records for each object number. The "problem" is
that many times the objects have been shipped multiple times, or the
objects require multiple crates. Those conditions are leading to
duplicates.
Any suggestions? Any report examples that you can share? Thanks in
advance!
David Armstrong
Database Administrator
MOCA THE MUSEUM OF CONTEMPORARY ART
|
|
|