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,