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 @ ABCfirm.com or www.mycompany 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.