that's fine with me. at least everyone by default wont be viewing an edit screen! ;-) so that is a HUGE improvement.
anytime before 3:45 eastern m-f is fine with me. -----Original Message----- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 11:29 AM To: [email protected] Subject: Re: [plum] Database Relationship Question Yeah, I remember us talking about your requirement for this at our office. It still makes my skin crawl because of all the problems this is probably going to call you, but if you insist... John, why don't we schedule a time for you to call me so that we can share my desktop while I model this up for you live using ER/Studio based on our discussion? 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: "John Stanley" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, June 08, 2005 8:23 AM Subject: [plum] Database Relationship Question > Hiya all, > > Just a general question. Trying to tap into the db expertise a bit, I guess. > > say I have a db with this table: > > shipment > > and these tables are dependent on the shipment table: > > quotes > cargo > notes > et al > > > then I have this table: > > lock > > and this table: > > description > > and in the lock table there is a column called lockType (int) which > corresponds to the description table PK. this will give the code an idea > which TABLE is being edited by the user. then the lockTypeID will tell the > code which of the ROWS in that table are currently locked for editing by the > user. > > basically this functionality is so that if a user attempts to EDIT some data > part on a shipment, the system will first check to see if it is locked by > another user, and if so, just direct them to the VIEW screen with an > appropriate message. > > with this schema I cannot make a fk relationship between the children tables > of the shipment table and the lock tables lockTypeID column. > > What kind of relationship is this called? > > Is it a bad thing to do it this way? If so, why? > > The only other solution I can see is to have one or more columns in each of > the editable tables I wish to control to store the locking information. > > Can you see any problems with either methods. > > Thanks to anyone who has some input. > > John Stanley > Web Application Developer > Active Aero Group > http://www.activeaero.com > 734-547-7200 office > > > > > > > > > ********************************************************************** > 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 **********************************************************************
