AnsweredAssumed Answered

" Trimming Down " a Value List

Question asked by BryanN on Jul 23, 2012
Latest reply on Jul 23, 2012 by BryanN


" Trimming Down " a Value List


See attached db relationships to help.


In order to relate work orders to child tables (packing lists, inventory, purchase orders, etc), I currently have a drop down list populated by a value list that will insert the work order's pk in the the child tables fk fields (it uses the pk serial# but shows the better known, manually assigned unique order# generated by employees to make it easy).


Issue here being that we will have about 6,000 jobs once I do my db import from accounting.  Not good to have a value list with 6,000+ jobs and growing.  


I remember something about table occurances and such to where you can run 'query' type calculations, but I don't know if that would apply here.  Once work orders are completed, they are marked with a status of 'closed'.  Ideally, I'd like to make the value list be populated with only '≠ closed' work orders.  Any suggestions as to how?