Lookup Values To Validate User Input Field Follow
I have a label created which looks up a part number (via an access DB), then returns fields required, which is all working well.
Now then, we have a text field on the data entry form which a user manually types a booking in number, is there any way I can get bartender to look at this field and compare it to a list of values for the given part number, to validate it?
My end result would go along the lines of..........if that part number doesn't have the same booking in number (compared to a list of possible options) as what the user types in, they will receive a message warning them that no part numbers on that booking in number exists.
We would also like the ability to override if possible, as there a sometimes exceptions to the rule
Hope this makes sense and hope someone could point me in the right direction
Please sign in to leave a comment.