In the Job Table, you can make a self relationship which matches a global calculation field "Active" with Status = "Active"...
Then, you can have a valuelist of the job numbers and only show related values to the Active jobs relationship.
Valuelists can be sorted according to the options at the bottom of that dialog.
Thank you for the reply,
You have again, helped me along your the best!