AnsweredAssumed Answered

Filtered Value Lists

Question asked by Jason_Farnsworth on Feb 13, 2014
Latest reply on Feb 13, 2014 by Jason_Farnsworth

I am still trying to get my head around filtering value lists and would be grateful for an intellectual boost.


I have a Job table w/ in that table I have (2) fields, Job number (a serial number) and Job Status (in process status).


Next I have a Timeclock table and a Timeclock_lineitems Table. The lineitems table handles things such as task and hours for the task, also most importantly Job Number. I am selecting a job number from a drop down list. Really Really Bad, I have a lot of job numbers and therefore the list just goes on and on and the time it takes to get to what I want is becoming a drag.


So I have job status also on the Job Table, in which could be used to filter off jobs that are not current and do not matter any more.


How can I make the value list relative to the Job status in the Job Table?


It is possible to sort the value list ascending or descending?


Thanks in advance,


Jason Farnsworth,

Midland, TX