Check if value exists before Insert
I have a form that is a normal insert form and it works fine. But what I need to do is compare one of the values in a text field to make sure it exists in another table before it Inserts.
So basically I am inserting a record into Table B, But I need to make sure that the value entered in one of the text fields is present in Table A before Inserting.
Is there a way to do this?