December 10, 2008 at 7:55 am
I have an application that has many lookup tables (for dropdowns, etc) of which many have an "Other" selection with a freetext box underneath. Right now we are storing some of the user-entered "Other" values alongside the standard FK data with a BIT column of "OtherValue" set to 1.
Is there a better way to do this? (in terms of performance/normalization/etc) What do you do?
Thanks
-Max
December 10, 2008 at 10:28 am
You could add the "Other" values to your lookup tables with an OtherFlag or ExcludeFlag and then filter them out on your selects for dropdowns. That would let you always save the LookupReference on your record.
Additionally this would allw them to "delete" a value from your lookup list (by changing the flag), but it would still exist for records referencing them.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply