View Single Post
Old 06-13-2012, 11:25 AM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,200
Karma: 5495470
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by seaquay View Post
I have two columns section and subsection. When I add new books, I first fill in the section (e.g. 'psychology', geography etc.). While entering new books, when I type a letter, I get all the previously entered unique data, which is great. I then proceed to fill in the subsection. I get all the previously entered data in this column, BUT I want only a subset of data that belongs to a particular section. For example, if under 'psychology', I have two subsections - 'Abnormal' and 'Clinical', and under 'geography', I have two subsections - 'Africa' and 'Asia'; then if I type 'Psychology' as the section for a new book and in the subsection I type 'A', I wish to see only 'Abnormal' and not 'Africa' and 'Asia'.
So I want the column 'subsection' to have data based on column 'section'.
Before someone points out, yes, using tags is a great idea, but I feel that I have better control here.
Would Text with a fixed set of permitted Values work (is not conditional on another column and I am not sure of how big a list it supports)
theducks is offline   Reply With Quote