Dynamic Entry Form

I need a dynamic entry form that will pull data from two SQL tables and modify the user's entry fields to 'clean' data. TABLE 1: tableFirm Fields: ( firmID, firmName, firmManager, firmPresident, firmSecretary, frimEarnings, firmEmployees, frimEmailaddress, firmWebsite...) TABLE 2: tablePersons Fields: ( personID, personFirstName, personLastNamee, personEmailaddress...) DATA ENTRY SCREEN The data entry screen will include text boxes for all the fields in table 1 and pull data from Table 2 as the user is entering data, in addition to 'clean' versions of those fields. The form will check to make sure the data entered is correct/valid Example 1: - persons when the user is entering the name of the firmManager (say "Robert Smith"), a list will pop up to select the correct Robert Smith [ there could be a Robert Smith at two different companies, so the list would need to show the name and email addresss ] the personID is what will be stored in the form, not the person's name Exapmle 2: - earnings (dollar signs and commas stripped out) when the user is entering the income, any non-numeric symbols should be stripped out ( so $7,000,000 is entered but 7000000 is stored) Example 3: - firmEmailAddress or firmWebsite when the user enters an email address that is not valid, a message pops up to alert him to correct (so John @ [login to view URL] or [login to view URL] would be invalid) This needs to be done in classic .ASP but you can use plugins that I will be able to modify if needed. I will give you access to a server that you can test it on. Once it is working, you will receive 50%. I will then move the files to a similar server and when that works, I will pay the remaining 50% Once selected, I will give you the details on actual field names, etc. I know this is a pretty simple project but if I find somebody that I work with well, there is more work. If you have a sample webpage that does something like this that you can point me to so I can see how well you did, that would be great. Thank you very much.