Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Thu, 28 Jul 2011 15:47:59 -0500 |
Content-Type: | text/plain |
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.
|
|
|