Gossamer Forum
Home : Products : DBMan : Discussions :

Unique entries filtering for field value

Quote Reply
Unique entries filtering for field value
Hi,

Would like to ask you is any easy way me to filter unique flat db entries (DbMan).
Let's say one db field called emp_types contains preset values (Secretary, Manager, Engineer, Builder)
another field called what contains preset values (good, bad, nice, lasy)
db sample
#ID #name #emp_type #what
1|Sarah A. | Secretary | nice
2|Jean S. | Secretary | nice
3|Lisa L. | Secretary | lasy
4|John M.| Manager | good
5|John O. | Manager | bad
5|Peter W. | Manager | lasy
I would like to build select fields that if you select Secretary in one, second provides existing values from db for secretary (i.e. lasy and nice)
if manager selected in first second provides options to choose from good and bad, but not nice, lasy or others

Selecting java will build myself, just need how to create lets say file with unique entries like form db example above file should look something like
Secretary |nice|lasy|
Manager |good|bad|lasy|

Any help would be appreciated.

thank you
eRBe
Subject Author Views Date
Thread Unique entries filtering for field value erbe 4392 Oct 27, 2005, 3:41 AM
Post Re: [erbe] Unique entries filtering for field value
LoisC 4293 Oct 27, 2005, 8:58 AM