Valadation and highlighting invalid fields
I have various text fields (service name, time name) set to validate to be a memeber of a list stored in other tables. When I enter a new record I am forced to pick from the drop down list that I set up. The problem is when I go to the list in the other table (source list) and make a change it doesn't update the other fields and then my portals are missing information. Can anyone tell me if there is a way to "flag" items that are not no longer valid, so I don't have to click on each field to check it? or even better when I update the source field (text) have it carry over to the other text fields? I have attached a screenshot of the way I have the field set up that I want to validate, I just don't know how to find out if someone changes the source field on me. Thank you.