On a form I have a part number field ( a text field), and a purchase order number field (also a text field).
The part number is always entered first. Then the user enters the purchase order number. But if there is already a record with the exact same purchase order number for that part number I want a message box to appear warning the user that tis purchase order already exists for that part number.
How can I do this?