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