on:
Say you have a dynamically driven select box:
What's your favorite fruit? [select name = "fruit"]
-Apples [value = 1]
-Oranges [value = 2]
-Other
-Not Applicable [value = NULL]
(Feel free to take issue with any of the following:)
I'd assign the "Not Applicable" option a value of NULL in the DB
field, so it would have neither a foreign key nor lookup value.
However...
1. Generally, should the "other" option be in the database (as a field
in the lookup table)?
2. Or alternatively, should the "other" option be a static one (if so,
how is it best represented in the DB)?
Thanks,
Jamie
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
