Sender: |
|
Date: |
Thu, 28 Jul 2011 15:47:59 -0500 |
Reply-To: |
|
Message-ID: |
|
Subject: |
|
MIME-Version: |
1.0 |
Content-Type: |
text/plain; charset="utf-8" |
In-Reply-To: |
|
Content-Transfer-Encoding: |
base64 |
From: |
|
Parts/Attachments: |
|
|
Thanks so much Ariana and everyone for the tips!!! All the constituents just came together :)
Stephanie
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of French, Ariana
Sent: Wednesday, July 27, 2011 1:55 PM
To: [log in to unmask]
Subject: Re: List Views & 1 to many relationships
Hi Stephanie,
I often use functions ("Scalar-valued Functions" in SQL Server 2005) to generate listview-friendly values for views. The function is passed the ObjectID as a parameter, and then COALESCE is used to string together the returned values.
Best,
Ariana
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Hansen, Stephanie
Sent: Wednesday, July 27, 2011 1:32 PM
To: [log in to unmask]
Subject: List Views & 1 to many relationships
Hello again,
Anyone have any tips on how to handle a 1-many relationship in a listview without returning multiple lines?
Thanks!
Stephanie Hansen
Milwaukee Art Museum
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
|
|