August 16, 201213 yr I have a table of Customers and a table of Quotes. I have a script in the Quotes that takes the customer name, phone and email, sets them to variables, opens a new record in Customers, and fills in the name, phone and email. The problem is, I want to be able to do a Find in there and basically say "OK, that customer is not in the Customer list, so we will add them" or "Oops, looks like the customer is in the customer table already, so we did not add them". I don't know how to have it do the find without prompts, and not sure how to have it know that if the customer is in there do this, and if the customer is not in there do that. Any help would be greatly appreciated!
Create an account or sign in to comment