Why would you want to clutter up your data table with 2 fields for every possible status (one for who last set it to that status and another for when that status was set)?
If you have 5 possible status values then you would have an additional 10 fields on your form. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Thursday, March 25, 2010 12:42 PM To: [email protected] Subject: General design question regarding H tables What would be the purpose of having a seperate table to hold the status values and not just have it in the orig table? -John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
