I'd like to create a value list that includes values from a field (records from a table). I only want it to include "active records" based on a "status" field on that record. So if the status field is set to "Ready" then that record would be included in the value list. If its set to "Not Ready" or "Waiting" it would not be included in that value list.
I've been finding lots of how-tos for nested hierarchal conditional lists where I select a category and then the next value list adjusts based on that category. But I just want the value list to automatically hide or show based on that status field. Is this possible?
I have tried creating a self-joined table that matches based on status and then had the value list only show values only include related values starting from the self-joined table. This seems to partially work as the value list only shows records with a certain status. But I don't know why its showing just that particular status, and I don't know how to adjust it so that it shows the records with the correct status.
Any help or point to a very simple tutorial would be greatly appreciated!