I have a table called CONTACTS, with ContactID (primary key), lastname, firstname, address, phone, etc.
I want to create a form that will take the input of lastname and firstname, then check against CONTACTS if the combination lastname||firstname is ther or not. If there, output some error, if not already there, present the user with all the other fields to input.
I envision the “query” form calling one of two other forms: a “that entry is already there” form or a form with the other entries to be filled out.
Is this possible with forms on its own or does there need to be some SQL checks behind it.
Thanks!