All should be just fine. We deal with multiple relationships between the same tables all the time, but they're mostly for custom-built interfaces rather than interfaces built using Plum form custom tags.
We'd be honored to join you for lunch or dinner. Thanks! :) 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: "Mark Fuqua" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, June 23, 2005 2:26 PM Subject: RE: [plum] quick sql question > So Adam, > > If I "hand code" without any of the plum custom tags, the view, delete and > delete action pages, all will be well? > > Are you ready for CFUnited? If you are not all booked, I'd love to take you > and David out to lunch or dinner. > > Thanks, > > Mark Fuqua > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Adam > Churvis > Sent: Thursday, June 23, 2005 1:56 PM > To: [email protected] > Subject: Re: [plum] quick sql question > > > There isn't *a* one-to-many relationship between those tables; there are > *two* one-to-many relationships between those tables. Always think of each > relationship as being separate. > > Plum can handle each of these as its own filtered select menu on add and > edit forms, but will screw up on view and delete forms because Plum doesn't > yet support column aliasing. It will in the next major release, but not > yet. > > 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: "Mark Fuqua" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, June 23, 2005 1:34 PM > Subject: [plum] quick sql question > > > > I have a table with the following fields > > > > NewMessageId (pk) > > NewMessageText > > MessageInitiatedBy (fk) > > MessageSentTo (fk) > > > > > > Both the messageInitiatedBy and MessageSentTo are foriegn keys relating to > > plumUser table. Is this legal? Is it still a one to many if there are > two > > fields in the same record that relate to the same table? > > > > > > Thanks, > > > > Mark > > > > > > > > ********************************************************************** > > 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 **********************************************************************
