I know that there is a way to do this just can find the best way. I want my employees to be able to key in an account number and the database return necessary information. There will be 6 or 7 fields that will populate. I have created an ODBC connection to the source. After the form is complete I want my employees to be able to hit the submit by email button and the form be emailed as well as saved back to a different Database.
Thanks
Brad