We are currently looking at rewriting our entry system and one issue that I am looking for some feedback involves the use of lookup tables and populating/editing screens. We are looking at creating a generic table that contains all the valid entries for each drop-down list. For example, we may display a list of valid states for the user to select. The proposed "edit" table contains a row for each state with the following columns as an example:
table_name: address column_name: state_cd code: WI description: Wisconsin In addition, we have situations on the screen where a user may select option 'a' in a drop-down list, but can not choose option 'c,d or f' in a different drop down list. Any suggestions for designing a flexible system that would incorporate issues like the above. We have been considering either "hard-coding" the edits within the screen as well as creating a "rules/validation" table that would incorporate these edits. How practical is a rules table? (We do have situations where we may have multiple entries to validate to each other). I realize these are very broad questions, so I am looking for generic theories that may be applied that are flexible for adapting to changes within the business. What else should I consider? It appears as if there are several ways to skin the cat how do we go about choosing the best method for our situation. In addition, does anybody know of any good websites/books that contain relational design strategies, tips ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
