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 **********************************************************************
