I'm working on a project that involves value list. I have a dropdown list of serial numbers that is being pulled from another table which has a field called status and this status field is a calculated field which changes its values from available, unavailable to other values. I would only want to display in my dropdown list values that are showing "available" in the status from the other table. Is there a way to do this fairly easy or there's no way to achieve it, I know there must be a way but just don't know how.
Thank you for the help in advance, any inputs is highly appreciated.