General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The vValid contains all the data for legit choices.
View Layout
-----------
UniqueID I
Category C 10
Descrip C 20
Category could be either STATE, COLLMETH or CARDTYPE.
I would use a join if possible but I'm not sure it can be done if all the valid picklist choices are in one table. I put it all together b/c we'll have many more picklists in the future and wanted to keep the number of tables to a minimum.
Thanks for the help.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only