" 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?