- This topic has 3 replies, 2 voices, and was last updated 1 year, 1 month ago by
.
-
When using values from an existing table for a pick list, is it possible to use only values where some column has a specified value
Table A
Columns C1 C2
Data:
C1 C2
T1 abc
T1 def
T2 ghi
T2 ijk
T3 lmm
Picklist from Table A
Display column C2
Use only rows where C1 = T1
Resultant List:
abc
def
ha ha, not surprising. I tend to think more generally…..I have a data base of vocabulary words. Just 1 table. I choose a general part of speech (verb, noun, adjective, etc) and then one or more subtypes which are dependent upon the part of speech. For a verb, that could be transitive, intransitive, reflexive and a few more. So it is a dependent picklist. Not sure if scripting could be used to populate the dependent picklist based upon the value in the part-of-speech field. I’m relatively new to Tapforms, and I must say that I’m impressed with what you’ve accomplished. I’m not new to databases however, been doing Oracle for 30 years on my jobs.
You must be logged in to reply to this topic.