Jeff, How did you end up creating the view? I have the same situation with the parent table having 3 fields that relate to the PK of a child table. I guess I need a view with one record, not 3, so I need to flatten it out somehow.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fleitz Sent: Thursday, June 16, 2005 3:41 PM To: [email protected] Subject: Re: [plum] Multiple joins to the same parent Thanks. That's the way I'll handle it, then. Adam Churvis wrote: > Unfortunately, there is no way to do this directly in the current > version of Plum. You can, however, create a view with these columns > aliased as you like and use that as your display table. > > We'll add this capability to the project plan for the next major > upgrade to Plum. > > Respectfully, > > Adam Phillip Churvis > Member of Team Macromedia > http://www.ProductivityEnhancement.com > > Download Plum and other cool development tools, and get advanced > intensive Master-level training: > > * C# & ASP.NET for ColdFusion Developers > * ColdFusion MX Master Class > * Advanced Development with CFMX and SQL Server 2000 > > ----- Original Message ----- > From: "Jeff Fleitz" <[EMAIL PROTECTED]> > To: "[email protected]" > <[email protected]> > Sent: Thursday, June 16, 2005 3:24 PM > Subject: [plum] Multiple joins to the same parent > > > >>Hi All, >> >>I have a situation where I have a child table with multiple foreign >>keys > > to the same parent (Company), and I want to > >>display the names (alternate key) of the each of companies on a single > > child view form. Is this possible? Is there a > >>way to Alias a table that I am not aware of? >> >>This is not a problem on an add/edit form, because the > > DisplayFilteredSelect tag has attributes which handle the primary > >>and foreign key specifications for you. This is not the situation with >>a > > DisplayColumnOnForm tag on a view form, however. > >>Looking for the best way to approach this. >> >>v/r, >> >>Jeff >> >> >>********************************************************************** >>You can subscribe to and unsubscribe from lists, and you can change >>your subscriptions between normal and digest modes here: >> >>http://www.productivityenhancement.com/support/DiscussionListsForm.cfm >>********************************************************************** >> > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
