you could try adding a recordset using table A, filtered by the post value of your form field
on your page, when the add record form is posted, the recordset will return 0 rows unless you have a match.
if you have a match, do the insert, if not, don't.