Conditional Drop Down list (finishing touches)
Problem: I have an item receipt that pulls info from an "Accountable Equipment" table. I have it filtering the "Product ID" shown based on the "Issued to" field (via a portal) using relationships. I assign individual equipment to people in the "Accountable Equipment" Table.
HERE is the problem; when I click on the "product ID" field in my portal, nothing shows up. But if I enter a value (even just a space) and click out of the field, when I click back into it, THEN the filtered values show up. How do I make it so that the filtered values show up immidiately?