LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

	LISTSERV Archives
	TMSUSERS Home

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

Options:	Use Monospaced Font Show Text Part by Default Show All Mail Headers
Message:	[<< First] [< Prev] [Next >] [Last >>]
Topic:	[<< First] [< Prev] [Next >] [Last >>]
Author:	[<< First] [< Prev] [Next >] [Last >>]

Subject:	Re: List Views & 1 to many relationships
From:	"French, Ariana" <[log in to unmask]>
Reply To:	The Museum System (TMS) Users
Date:	Wed, 27 Jul 2011 18:55:12 +0000
Content-Type:	text/plain
Parts/Attachments:	text/plain (1 lines)

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.

ATOM RSS1 RSS2

SI-LISTSERV.SI.EDU