Serving businesses throughout North America since 1998

Oracle, Linux and Lims - Programming, Installation, Consulting

Foreign Keys

Ok, so I recently got burned by not having a foreign key defined on a table. I know, bad practice, but it happens. Anyway, without the foreign key a user was able to remove a record from the shipping methods table which caused the Oracle Form to not display a specific client account. Wondering how that could be? Yeah, so did I, for hours. Turns out the shipping method field in the accounts block is a pop-list which is pre-filled from the shipping table and when the form queried the record, it didn't display because the value wasn't in the pop-list. And of course the client services folks really, really NEEDED to see that account record....

I double check my foreign keys now. You should too.

www.limsguy.com - Copyright (c) 2011 - Scott Johnston Inc. All rights reserved.